![]() ![]() ![]() The first step is to create a list of sheets that people need to go to. In the cell below that, a hyperlink that will take you to the selected sheet. To make it easy to go to a specific worksheet, we’ll build a drop down list that shows the sheet names. ![]() That’s not too efficient! The Finished Sheet Selector Right-click on the sheet navigation arrows, to see a list of sheetsīut how do you really find a sheet most of the time? I usually click the sheet navigation arrows, and look for the sheet name as the sheets fly past.Ctrl+Page Down to go the previous sheet.To navigate through a large workbook, you can use keyboard or mouse shortcuts: Once they’re on one of the other sheets, how can they get back to the table of contents, or go directly to a different sheet? We’ll add a drop down list of sheets, to make it easy to go to the one that you need. You can create a table of contents on the first sheet, and that will get them off to a good start. If you’re setting up a workbook for other people to use, they’ll appreciate it if you make it easy to move around in the file. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |