TheExcelAddict .com
Microsoft Excel 'Quick Tip'

Zipping Through Your Sheet Tabs

Here's a little trick I always use that may look a little strange at first, but it 'works for me.'

You've heard me before recommending that you learn both a 'mouse method' and a 'keyboard method' for doing things in Excel. Well, here's another one to add to your bag of tricks.

You probably know that when you have a lot of sheets in your workbook, you can use the sheet tab scrolling buttons on the bottom left of the Excel window to navigate among your workbooks. I use that method too when I am in 'mouse mode.' But anytime you have both hands on the keyboard and you need to move quickly from one worksheet to another, here's what you can do.

When you've got a workbook that has a lot of sheets (i.e. more than ten) and you need to move between sheets on opposite ends of the scroll tabs, hold down the CTRL key and press and hold the Page Up (scroll left) or Page Down (scroll right) button. You will quickly scroll through the sheet tabs and get to the opposite end in a second or two.

When you 'turbo-scroll' like this through a workbook containing 30 or 40 sheets, it may look a little funny but, hey, it works.

Why not print (CTRL+P) this tip and
share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict".
Subscribe at the TheExcelAddict.com/Newsletter.htm and you could win a really cool prize.
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright All Rights Reserved by

Close this window