shortcuts

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Shortcuts

Shortcuts

resolvedResolved · Low Priority · Version 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

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

View all Excel hints and tips


Server loaded in 0.12 secs.