Microsoft Excel Shortcuts

Microsoft Excel Shortcuts
Navigation
CTRL + TAB	To toggle between open workbooks, hold CTRL, then press tab
CTRL + Pg Up	Switches to the preceding sheet in the same workbook
CTRL + Pg Dn	Switches to the next sheet in the same workbook
CTRL + F9	Minimize Workbook
CTRL + F10	Maximize Workbook
CTRL + End	Moves to the last cell in a working area
CTRL + Home	Moves to the first cell of a worksheet
CTRL + ←	Moves to leftmost cell of a data block
CTRL + →	Moves to rightmost cell of data block
CTRL + ↓	Moves to top-most cell of data block
CTRL + ↑	Moves to bottom-most cell of data block
Tab	Moves between selected cells in a range
Home	Moves to beginning of the current row
Pg Up	Scrolls the window up one screen
Pg Dn	Scrolls the window down one screen
ALT + Pg Dn	Scrolls the window right one screen
ALT + Pg Up	Scrolls the window left one screen
End, Enter	Moves to the last cell in the current row that contains data
F5 or CTRL + G	Go to specific cell or range
CTRL + F	Find a specified cell value
CTRL + F1	Toggle Task Pane
Selection
CTRL + SHIFT + ←	Select from current cell to leftmost cell of a data block
CTRL + SHIFT + →	Select from current cell to rightmost cell of data block
CTRL + SHIFT + ↓	Select from current cell to top-most cell of data block
CTRL + SHIFT + ↑	Select from current cell to bottom-most cell of data block
CTRL + A	Selects entire worksheet or data set (when not entering or editing a formula)
CTRL + SHIFT + *	Selects entire block of data
CTRL + spacebar	Selects entire column
SHIFT + spacebar	Selects entire row
CTRL + D	Fills selected range of cells downward
CTRL + R	Fills selected range of cells to the right
Formatting
ALT + Enter	New Line within a cell (carriage return)
CTRL + 1	Display the Format Cells dialog box
CTRL + '	View Formulas instead of Values in all Cells. Repeat to get back to Values view
CTRL + SHIFT + ~	Applies gen. number style
CTRL + SHIFT + $	Currency number style
CTRL + SHIFT + %	Percent number style
CTRL + SHIFT + ^	Exponential number style
CTRL + SHIFT + #	Date number style
CTRL + SHIFT + @	Time number style
CTRL + SHIFT + !	Comma number style
CTRL + SHIFT + &	Adds outline border
CTRL + SHIFT + _	Removes outline border
F11	to create a chart as a new worksheet from highlighted cells
'	Place ' before anything you don't want excel auto formatting for you
DoubleClick Format Painter Button	Copy text format and Paint the format on multiple objects
Editing
CTRL + O	Open existing workbook
CTRL + N	Open new workbook
SHIFT + F11	Insert Worksheet
Double-Click or F2	Edit contents of a cell
SHIFT + F2	Edit cell comment
Double-Click on the lower right corner of a cell	Fill down
CTRL + SHIFT + "+"	Insert Row
CTRL + SHIFT + "-"	Delete Row
CTRL + "-"	Delete Cell
CTRL + ;	Enters current date
CTRL + SHIFT + :	Enters current time
CTRL + H	Find and Replace text
CTRL + C	Copies text to the Clipboard
CTRL + X	Cuts text to Clipboard
CTRL + V	Paste text to the Clipboard
CTRL + Z	Undoes the most recent command
CTRL + Y or F4	Redoes an undone command
CTRL + K	Insert Hyperlink
F9	Calculate all sheets in all open workbooks
SHIFT + F3	Insert a function into a formula
SHIFT + F9	Calculate the active worksheet
CTRL + select worksheets	Modify multiple sheets at once