I have a relatively simple Excel task (I hope). One workbook, two sheets (Sheet1 and Sheet2) Sheet 1 has a dropdown Data Validation list that has 30 options. The user will choose an option from ...

Repeat this action with any other sheets of your Excel worksheet. You can access the various sheets (usually named "Sheet1," "Sheet2" and "Sheet3" by default) at the bottom of the workbook file.

Click the upper-left cell in the range with the border you want to copy. Drag your cursor to the range's lower-right cell, selecting the entire range. Click "Home" on Excel's menu bar.