In her regular series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she explains how to flip through your worksheets (Microsoft Excel).
Tame your computer - flippin' easy shortcuts
Moving the cell pointer from one worksheet to another worksheet in the same workbook can be done with either a mouse or the keyboard. Anybody who ever attended one of my courses or is an astute reader of this tip series knows I absolutely love keyboard shortcuts. So unless you really want to pick up your mouse and click on the worksheet tab at the bottom of the workbook window or use the tab scrolling buttons to the left of the worksheet tabs, try out these nifty keyboard shortcuts.
- Press CTRL + PGUP to jump to the last selected cell in the previous worksheet.
- Press CTRL + PGDN to jump to the last selected cell in the next worksheet.
It doesn’t matter whether you use the Page Up and Page Down buttons on the numeric keypad or elsewhere on the keyboard.
Our current course schedule can be found online. Book more than one person from your organisation on the same course, on the same date, and you get 10% off.
Highly respected training company, specialising in Excel, Word, PowerPoint and Outlook. Since 2001 we have successfully developed and delivered training courses for public and private clients, large and small, across 23 countries around the world. We feel passionate about sharing the best of what we know with others and strive to help as many people as we can.