Tame your computer - flippin' easy shortcuts


01-11-2019
Roem Tip TIme logo

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).

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.

Here’s how:

  1. Press CTRL + PGUP to jump to the last selected cell in the previous worksheet.
  2. 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.

Related tips:

Switching between multiple browser tabs

Preview and flip through your open windows

Use a keyboard shortcut to switch between open workbooks

Flip through the tabs of a dialog box

Upcoming courses

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.

 

I November 2019

Karen Roem offers software training and support through her company Roem Ltd.  Contact her by email (Karen@roem.co.uk) or visit her website at  www.roem.co.uk

 

 

 

Highly respected computer software training company based in Cambridge. Registered supplier to local companies such as AstraZeneca, University of Cambridge, South Cambridgeshire District Council and NHS England.

Roem Ltd – software training and support