0

I found myself often have to switching between different worksheets in the same workbook, especially when there are more than 5 worksheet in the same file with long names, its really tedious work to simply locating the correct worksheet. One always have to keep scrolling the tabs.

Is there any way to easily switch between many worksheets in the same workbook?

Improve this question
1
  • You can use Ctrl + Pgup/PgDn to cycle through sheets, but I don't know of anyway to switch directly to a sheet you can't currently see.
    – Michael Frank
    Apr 20, 2017 at 4:24

2 Answers 2

Reset to default
0

The following screenshots are from Excel 2016, but it'll work under Excel 2010 as well. If you right click on the left/right arrows by the Sheets, it'll show you a list of all your Sheets.

Excel 2016

enter image description here

Improve this answer
1
  • Actually I just bumped into this menu today, Hence this question (see if there's any approach even better). Never realized its existence.but it really makes life easier, Never understand why those tabs still go horizontal in the wide screen days. Really awkward to keep scrolling all the time!
    – Ben
    Apr 20, 2017 at 7:03
0

I am not able to comment as I don't have enough reputation.

you may want to have a look on this
(it creates a 'table of conten't worksheet in your workbook)

best: to try on this, first insert empty row to every worksheet in this workbook

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .