I have a large workbook in Microsoft Excel 2013, with about 20 spreadsheets. The names are sort of long, so I can only see 5-7 at a time, with a very small scrollbar for navigating each spreadsheet.

Is there a way to have 2 rows in Excel, one for scrolling and clicking on spreadsheets, and one for scrolling the current spreadsheet?


I have never found anything handy like that.

An alternative, is if you right click on the sheet navigation buttons, in the lower left corner, it will give you a list of sheets to choose from. This can save time moving to sheets that may not be in view.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.