Navigating Spreadsheet
Posted by Matt Evans on October 22, 2001 9:22 PM
I have a spreadsheet with a large number (~30) of tabs, then a couple of summary pages at the end that reference cells among the 30 tabs. Problem is, I have to adjust these references periodically. Is there an easier way to go back and forth between spreadsheet pages in this large workbook? I know I could just move the summary pages around, but it seems like there must be an easier way. Thank you
Posted by Jonathan on October 22, 2001 9:42 PM
I suppose ou could have a simple macro, like one line,
Sheets("Summary1").Activate
and put a button in your toolbar that's tied to this macro. Click the button, go to the sheet.
HTH
Posted by Tom Urtis on October 22, 2001 9:57 PM
A speed tip for sheet navigation
Matt,
In your case, I bet 25 of your 30 worksheets are not visible past the horizontal scroll bar, and it sounds like you want to go to any given one quickly.
A speed tip: right-click onto any of the sheet scrolling buttons (those 4 arrow-looking buttons to the left of, and on the same line as, the sheet tabs). This will display a shortcut menu showing all the sheet names in the order in which you have them in your workbook from left to right. Once those names pop up, left-click on the sheet name of your choice to jump directly to that sheet.
Tom Urtis
