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