|
EXCEL SHORTCUTS
Below is a list of useful shortcuts available when using Microsoft Excel.
General:
Ctrl & X.................................Cut
Ctrl & C.................................Copy
Ctrl & V ................................Paste
Ctrl & Z ................................Undo
Ctrl & Y ................................Redo
Ctrl & S.................................Save
Ctrl & P ................................Print
Ctrl & F ................................Find
Ctrl & Shift & " ....................Copy cell above
Ctrl & R ...............................Fill to the right
Ctrl & D................................Fill to the left
Ctrl & ; ................................Enters and fixes the current date
Ctrl & Shift & : .....................Enters and fixes the current time
Alt & = .................................Inserts the AutoSum formula
F11.......................................Inserts a chart
Shift & F2..............................Insert or edit a comment
Shift & F11............................Inserts a new worksheet
F9..........................................Forces the worksheet to recalculate
F1.........................................Displays the Help file
F7.........................................Spell checker
Navigating around worksheets:
Return........................Moves down one cell
Shift & Return.............Moves up one cell
Tab.............................Moves one cell to the right
Shift & Tab..................Moves one cell to the left
Arrow keys.................Move up, right, down or left one cell
Home..........................Moves to the start of the current row
Ctrl & Home................Moves to the cell A1, top left corner
Ctrl & End...................Moves to the last active cell in the worksheet
Ctrl & Arrow key.........Moves to the end of a data block, or if empty to the end of the sheet
PageUp.......................Moves up one screen
PageDown..................Moves down one screen
Alt & PageUp...............Moves one screen to the left
Alt & PageDown..........Moves one screen to the right
Ctrl & PageUp..............Moves to the previous worksheet
Ctrl & PageDown.........Moves to the next worksheet
Ctrl & Tab....................Moves to the next open workbook
Ctrl & Shift & Tab.........Moves to the previous open workbook
F5................................Displays the Go To window
Selecting Cells:
Shift & Arrow key.............Expands selection in the chosen direction
Shift & Home....................Expands selection to column A
Ctrl & *............................Selects the current region (You will need to hold down the shift key while pressing 8 if using the main keyboard; alternatively use the * key on the number pad).
Ctrl & Spacebar................Selects the entire column
Shift & Spacebar..............Selects the entire row
Ctrl & Shift & Spacebar ....Selects the whole worksheet
Ctrl & A.............................Selects the whole worksheet
Editing in the Formula Bar
F2.....................................Switches to edit mode in the selected cell
Arrow keys.......................Moves the cursor one character in the chosen direction
Ctrl & Right Arrow.............Moves the cursor one word, number or cell reference to the right
Ctrl & Left Arrow...............Moves the cursor one word, number or cell reference to the left
Home................................Moves the cursor to the start of the formula line
End...................................Moves the cursor to the end of the formula line
Del....................................Deletes the character to the right of the cursor
Ctrl & Del..........................Deletes all characters from the cursor to the end of the formula line
Backspace........................Deletes the character to the left of the cursor
Esc...................................Cancels the edit
F3.....................................Pastes a name into a formula
Shift & F3..........................Pastes a function into a formula
Ctrl & A .............................Displays the Arguments window after typing a function name
Ctrl & Shift & A..................Displays the argument names and brackets in the formula bar after typing a function name
Alt & Return......................Includes a soft return in a formula allowing you to separate long formula into separate lines
Auditing worksheets:
Ctrl & `..............................Switch worksheet to formula view
Ctrl & [ ..............................Jump to precedents of selected cell
Ctrl & ] ..............................Jump to dependents of selected cell
Formatting Cells:
Ctrl & 1...............................Displays the Format Cells window
Ctrl & B...............................Bold
Ctrl & I ...............................Italics
Ctrl & U...............................Underline
Ctrl & Shift & ~ ...................General number format
Ctrl & Shift & ! ...................Comma format
Ctrl & Shift & %...................Percentage format
Ctrl & Shift & $ ...................Currency format with two decimal places
Ctrl & #...............................Date format (dd-mmm-yy, for example 01-Jan-06)
Ctrl & Shift & @...................Time format (hh:mm, for example 13:30)
Ctrl & Shift & & ...................Outline border
Ctrl & Shift & _ ...................Removes all borders
Hide and Group data:
Ctrl & 0 ...............................Hide columns
Ctrl & Shift & ) ...................Unhide columns
Ctrl & 9 ...............................Hide rows
Ctrl & Shift & ( ...................Unhide rows
Alt & Shift & Right Arrow.....Group columns or rows
Alt & Shift & Left Arrow.......Ungroup columns or rows
Ctrl & 8 ...............................Display or hide outline symbols
| 
