Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

shortcuts

ResolvedVersion 2003

Elsa has attended:
Excel Intermediate course

Shortcuts

Can you suggest shortcuts that minimise use of the mouse when navigating in a worksheet, and across worksheets? thanks!

RE: Shortcuts

Hi Elsa

Thank you for your question; and welcome to the forum.

Here are some keyboard shortcuts you might find useful when navigating around a spreadsheet (you can find these and other shortcuts by searching for keyboard shortcuts in Excel help):

Arrow keys
Move one cell up, down, left, or right.

CTRL+arrow key
Move to the edge of the current data region.

HOME
Move to the beginning of the row.

CTRL+HOME
Move to the beginning of the worksheet.

CTRL+END
Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column.

PAGE DOWN
Move down one screen.

PAGE UP
Move up one screen.

ALT+PAGE DOWN
Move one screen to the right.

ALT+PAGE UP
Move one screen to the left.

CTRL+BACKSPACE
Scroll to display the active cell.

TAB
Move between unlocked cells on a protected worksheet.

I hope you find these useful.
Amanda

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.