Tip o’ the Week #19: Navigating multi-sheet Excel workbooks

clip_image002Here’s a quick tip for Excel junkies. If you are using workbooks with many sheets, or where tab names are long, it can take a fair bit of scrolling around at the bottom of the Excel window.

If you right-click on the navigation buttons shown to the left of the tabs/sheets, Excel will throw up a list of all the sheets, and you can jump to the appropriate one with a single click.

Here’s a particularly large sales spreadsheet, for one:


Technorati Tags: ,,

Leave a Reply

Your email address will not be published. Required fields are marked *