Excel Shortcuts

Formatting
Keystroke	Function
[Ctrl]B	Bold the selection
[Ctrl]I	Italicize the selection
[Ctrl]U	Underline the selection
[Ctrl]5	Strike through the selection
[Alt] and '	Open the Style dialog box
[Ctrl]1	Open the Format Cells dialog box
[Ctrl][Shift]~	Apply General format
[Ctrl][Shift]$	Apply Currency format
[Ctrl][Shift]%	Apply percentage format
[Ctrl][Shift]#	Apply Date format
[Ctrl][Shift]@	Apply Time format
[Ctrl][Shift]!	Apply Number format
[Ctrl][Shift]^	Apply Exponential number format
[Ctrl][Shift]&	Apply an outline border to selection
[Ctrl][Shift] and _	Remove outline border from selection
Navigation
Keystroke	Function
[Ctrl][Page Down]	Move to the next worksheet in a workbook
[Ctrl][Page Up]	Move to the previous worksheet in a workbook
[Ctrl][F6]	Cycle between open workbooks
Arrow keys	Move one cell up, down, left, or right
[Ctrl] and an arrow key	Move to the edge of the data region
[Home]	Move to the beginning of a row
[Ctrl][Home]	Move to the beginning of a worksheet
[Ctrl][End]	Move to the end of the used portion of a worksheet
[F6]	Move between panes in a split worksheet
[Ctrl][Backspace]	Display the active cell
[Enter]	Move down a cell in a selected range
[Shift][Enter]	Move up a cell in a selected range
[Shift][Tab]	Move one cell to the left in a selected range
[Ctrl] and . (period)	Move from corner cell to corner cell in a selected range
Selection techniques
Keystroke	Function
[Shift][Spacebar]	Select a row
[Ctrl][Spacebar]	Select a column
[Ctrl]A	Select an entire worksheet
[Shift][Home]	Select from current cell(s) to the beginning of the row
[Shift][End][Enter]	Select from current cell(s) to last used cell in row
[Ctrl][Shift][Home]	Select from current cell(s) to the beginning of the worksheet
[Ctrl][Shift][End]	Select from current cell(s) to the end of the used portion of a worksheet
[Ctrl] and *	Select the data region surrounding the active cell
[Ctrl][Shift]O	Select all cells that contain a comment
[Ctrl] and [	Select cells that a selected formula directly references
[Ctrl] and ]	Select formulas that directly reference the active cell
Workbook basics
Keystroke	Function
[Ctrl]O	Open a workbook
[Ctrl]N	Create a new workbook
[Ctrl]S	Save a workbook
[F12]	Open the Save As dialog box
[Ctrl]P	Print a workbook
[Ctrl]W	Close a workbook
[Shift][F11]	Insert a new worksheet
[Ctrl]9	Hide selected rows
[Ctrl][Shift]9	Display hidden rows in selection
[Ctrl]0	Hide selected columns
[Ctrl][Shift]0	Display hidden columns in selection
[Ctrl]F	Open the Find tab of the Find And Replace dialog box
[Ctrl]H	Open the Replace tab of the Find And Replace dialog box
[F7]	Run a spelling check on a worksheet or selected text
Working with data
Keystroke	Function
[Enter]	Complete an entry and move to the next cell
[Alt][Enter]	Insert a new line within a cell
[F2]	Enable editing within a cell
[Ctrl][Enter]	Fill selected cells with an entry you type
[Ctrl]D	Fill data down through selected cells
[Ctrl]R	Fill data through selected cells to the right
[Ctrl][F3]	Create a name
[Ctrl]K	Insert a hyperlink
[Ctrl] and ; (semicolon)	Insert the current date
[Ctrl] and : (colon)	Insert the current time
[Ctrl]X	Cut the selected text or objects to the Clipboard
[Ctrl]C	Copy the selected text or objects to the Clipboard
[Ctrl]V	Paste the contents of the Clipboard
[Ctrl]Y	Repeat last action
[Ctrl]Z	Undo last edit
[Ctrl][Delete]	Delete from the insertion point to the end of the line
[Ctrl][Shift]+	Add blank cells
[Ctrl]- (hyphen)	Delete selected cells
[F11]	Create a chart from a range of data
Formula shortcuts
Keystroke	Function
=	Begin a formula
[Ctrl][Shift][Enter]	Enter a formula as an array
[Shift][F3]	Display the Insert Function dialog box (Paste Function in Excel 97)
[F3]	Paste a defined name into a formula
[Alt]=	Insert a SUM AutoSum formula
Type a function in the Formula bar and press [Ctrl]A	Display the Function Arguments dialog box
[Ctrl][Shift] and "	Copy the value from the cell above the current cell into the current cell
[Ctrl] and '	Copy a formula from the cell above the current cell into the current cell
[Ctrl] and `	Toggle between display of formulas and cell values
[F9]	Calculate values for sheets in all open workbooks
[Shift][F9]	Calculate values for the current worksheet
[Esc]	Cancel an entry you're making in a cell or in the formula bar