Excel Shortcuts Quick Reference

[Pages:1]Excel Shortcuts Quick Reference

CTRL+O CTRL+N CTRL+P CTRL+S CTRL+W CTRL+F2 F9 SHIFT+F9 CTRL+F10 SHIFT+F11 F12

WORKBOOK

Opens a workbook Create a new workbook Displays the print dialog box Save the workbook Closes the selected workbook Displays print view Calculates all open workbooks Calculates the active worksheet Maxmize / restore workbook Inserts a new worksheet Displays the Save As dialog box

FORMATTING

CTRL+SHIFT+~ Applies general format

CTRL+SHIFT+$ CTRL+SHIFT+%

Applies currency format with two decimal places Applies percentage format with no decimal places.

CTRL+SHIFT+# Applies date format CTRL+SHIFT+@ Applies time format

CTRL+SHIFT+! CTRL+1

Applies the Number format with two decimal places, thousands separator Displays the Format Cells box

GENERAL

CTRL+~ SHIFT+F3

Toggles values and formulas Insert Function dialog box

CTRL+F3

Name manager box

ALT+M+V

Evaluate formula box

CTRL+SHIFT+U Expand /collapse of the formula bar

CTRL+F1

Displays or hides the Ribbon

CTRL+SHIFT+L Applies / removes filter

ALT+A+Q ATL+T+O

Advanced filter Excel options

SELECTION

CTRL+A F8

Selects the entire worksheet (Press 3 times) Toggles extend mode

CTRL+SPACEBAR Selects an entire column

SHIFT+SPACEBAR Selects an entire row

EDITING

CTRL+SHIFT+: Enters the current time

CTRL+;

Enters the current date

CTRL+C

Copies the selected cells

CTRL+D CTRL+R CTRL+F

Copies topmost cell of a range into the cells below Copies leftmost cell of a range into cells to right Find dialog box

CTRL+H+ CTRL+K

Replace dialog box Edit hyperlink

CTRL+T CTRL+V

Create Table dialog box Paste

CTRL+ALT+V Paste Special Dialog box

CTRL+X

Cuts the selected cells

CTRL+Z

Undoes last action

SHIFT+F2 F4

F7

Adds / edits comment

Generates absolute and relative references Spell check

ALT+=

Autosum

ALT+F8

Opens Macro Dialog box

ALT+F11 ALT+D+P

Opens VB Editor Opens pivot table wizard

ALT+A+M

Removes duplicates

ALT+A+E

Text to columns Wizard

ALT+ENTER Enters a new line

ALT+D+L

Data validation

NAVIGATION

TAB

Left cell to right cell

SHIFT+TAB Right cell to left cell

CTRL+G or F5 Go To dialog box

CTRL+END Moves to last used cell

CTRL+Home ALT+PAGE DOWN CTRL+PAGE DOWN ALT+PAGE UP

CTRL+PAGE UP CTRL+Arrow

Moves to the first used cell

Moves one screen to the right in a worksheet. Moves to the next sheet in a workbook Moves one screen to the left in a worksheet Moves to the previous sheet in a workbook Moves to the edge of the current data region

?

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download