Outlook Reading Pane

Disabling the Word 2007 Mini-Toolbar

Excel Sheet Navigation

4Networking in Leeds East

Twitter - ReTweets

Twitter - Lists

Twitter - Mobile

Excel Paste Column Widths

PowerPoint Slide Master

Windows 'God Mode'

Excel Functions

Filling Alternate Cells

Microsoft Office Shortcut keys

Excel Negative Times

Word Reading Layout

Windows Shortcuts

Excel dropdowns

Quick sheet selection

Search files on Google

A - Z of Excel

Word 2003 to 2007

   Astradyne Blog/Tips and Tricks - Excel sheet navigation

Most people that use Excel have workbooks with multiple sheets. If there are only three or four sheets, no probs, but if there are more than that, it can be difficult to switch between sheets as you may not be able to see all the sheet tabs at once.

Of course, we can use the built-in sheet navigation buttons that take us to the first, previous, next or last sheets, but there are a few other techniques we can use to speed us up.

Many people know that we can press Ctrl-PageUp to go to the previous sheet, and Ctrl-PageDown for the next one.

A lovely trick though is to right-click on the sheet navigation buttons:

A pop-up list of sheets appears! This is my favourite sheet navigation trick. Simply click the name of the sheet you wish to use.

More tricks and shortcuts every day at Twitter –


Copyright ©2006-2013

vb training leeds, vba training leeds, excel vba, access vba, pc training in leeds, computer training in yorkshire, pc training in yorkshire, computer training in leeds, microsoft access vb, microsoft excel vb training, microsoft powerpoint training, microsoft training, microsoft word, office 2000, excel training leeds, access training leeds, office training leeds, office 2007, leeds vba, leeds visual basic, leeds training