Navigation tip I'd never read before

[nbrcrunch]

This past weekend I had some free time and decided to go to the local Barnes & Nobles bookstore with a pen & pad and see what I could glean from various advanced and/or special focus groups (Excel for Accountants, Excel for Engineers, etc) books.

I came across a navigation tip that you'd expect to find in every Excel beginner's book ever published. I've never seen it.

At the bottom left corner of Excel are two back and two forward buttons. Right-click any of them and a shortcut list pops up displaying all the sheets in the file. This is EXCELlent for those who have too many tabs to see without scrolling.

(I wish I could remember which book it was, but I looked through 4 different Excel books. Yes, I know I'm a geek. )

 

[Zack Barresse]

Yup, excellent tool. A lot of people try to remake this with custom menus and macros, but can't come close to the native functionality and speed of this very cool feature.

 

[starl]

Page 12 in MrExcel on Excel

 

[nbrcrunch]

well now I'm embarrassed. I have that book. Read it from cover to cover. Its very dog-earred from constant reference. I don't remember that. I'll have to look it up.

 

[Greg Truby]

And just in case you'd ever want to add custom menu options w/ VBA, that particular menu is named the "Workbook Tab" menu.

[For example, I use the open method of my Personal WB to add custom menu options to sort a workbook's tabs & to unhide hidden worksheets (I duplicated the regular menu's dialog box with a userform, but my UF allows for multiselect and it lists VeryHidden sheets.)]