Archive for the ‘Office’ Category

Keyboard Shortcuts

Wednesday, September 12th, 2007

Excel - Moving and scrolling within worksheets

Move one cell up, down, left or right -> Arrow keys

Move one cell to the right -> TAB

Move one cell to the left -> SHIFT+TAB

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

Move to the beginning of the row -> HOME

Move to the beginning of the worksheet -> CTRL+HOME

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

Move down one screen -> PAGE DOWN

Move up one screen -> PAGE UP

Move one screen to the right -> ALT+PAGE DOWN

Move one screen to the left -> ALT+PAGE UP

Switch to the next pane in a worksheet that has been split -> F6

Switch to the previous pane in a worksheet that has been split -> SHIFT+F6

Scroll to display the active cell ->CTRL+BACKSPACE

Display the Go To dialogue box -> F5

Display the Find dialogue box -> SHIFT+F5

Repeat the last Find action -> SHIFT+F4

Move between unlocked cells in a protected worksheet -> TAB