MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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