Monday, August 08, 2005

Sheet Tabs Shortcuts


Sheets in Excel Workbooks are accessed with the mouse by clicking on the sheet tab at the bottom of the screen.
There are a number of short cuts that can be used instead.
CTRL PAGEUP and CTRL PAGEDOWN will cycle through the sheets with PAGEUP taking you left and PAGEDOWN right.
When you have more sheet tabs than can be displayed on the screen you can increase the amount of space by dragging the scroll bar slider right. However once you have run out of room here there are some buttons at the very left of the sheet tabs that are very useful.
These are similar to a CD player controls with the outer arrows taking you to the front and end of the sheet tabs. The center arrows selects the next sheet up and down from the current sheet.
Additionally right clicking on these arrows displays a list of all sheet tabs that can be accessed. If there are more sheet tabs than this can handle it displays a More Sheets option.