98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Shortcuts
Shortcuts
Resolved · 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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Copying Formulae QuicklyThere is a quicker way of copying a formula down a column. |