Quickly select a spreadsheet

July 7, 2006

Excel workbooks can contain many spreadsheets – indeed the max is limited only by memory. Navigating a workbook containing many spreadsheets can be annoying – scrolling back and forth looking for the spreadsheet you want to work with, or using keyboard shortcuts to flip through many sheets is really inefficient.

Here’s a quick way to jump to the spreadsheet you want to work with:

Right-click any of the navigation arrows (located towards the lower left of the workbook window). Choose the desired spreadsheet from the resultant shortcut menu. Fast!

xl_sel_ssheet.png

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: