Excel Shortcut And Function Keys

The following sections cover some of my favorite shortcut keys. Try to incorporate one new shortcut key every week into your Excel routine. The problem with a list of hundreds of shortcut keys is that it is overwhelming. You cannot possibly some new shortcut keys and start using them. The following sections cover some of my favorite shortcut keys. Try to incorporate one new shortcut key every week into your Excel routine. Improving your Excel skills is a great place to begin to claw back a few minutes on every project, because Excel is a tool used by most of us on a regular basis. It has so many incredible capabilities that are not immediately apparent. Just finding one trick can save you minutes every day.

Shortcut key	Action	Menu equivalent comments	Version
Ctrl+’	Copy Formula from Cell Above	Edit, Copy	All
Alt+’	Format Style dialog box	Format, Style	All
Shift+Spacebar	Select the entire row	None	Excel 97/2000 +
CTRL+/	Select the array containing the active cell.
CTRL+SHIFT+O	Select all cells that contain comments.
CTRL+\	In a selected row, select the cells that don’t match the formula or static value in the active cell.
CTRL+SHIFT+|	In a selected column, select the cells that don’t match the formula or static value in the active cell.
CTRL+[	Select all cells directly referenced by formulas in the selection.
CTRL+SHIFT+{	Select all cells directly or indirectly referenced by formulas in the selection.
CTRL+]	Select cells that contain formulas that directly reference the active cell.
CTRL+SHIFT+}	Select cells that contain formulas that directly or indirectly reference the active cell.
ALT+;	Select the visible cells in the current selection.
SHIFT+BACKSPACE	With multiple cells selected, select only the active cell.
CTRL+SHIFT+SPACEBAR	Selects the entire worksheet. If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. Pressing CTRL+SHIFT+SPACEBAR a second time selects the entire worksheet. When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet
Ctrl+A	Select All	None	All
Ctrl+B	Bold	Format, Cells, Font, Font Style, Bold	All
Ctrl+C	Copy	Edit, Copy	All
Ctrl+D	Fill Down	Edit, Fill, Down	All
Ctrl+F	Find	Edit, Find	All
Ctrl+G	Goto	Edit, Goto	All
Ctrl+H	Replace	Edit, Replace	All
Ctrl+I	Italic	Format, Cells, Font, Font Style, Italic	All
Ctrl+K	Insert Hyperlink	Insert, Hyperlink	Excel 97/2000 +
Ctrl+N	New Workbook	File, New	All
Ctrl+O	Open	File, Open	All
Ctrl+P	Print	File, Print	All
Ctrl+R	Fill Right	Edit, Fill Right	All
Ctrl+S	Save	File, Save	All
Ctrl+U	Underline	Format, Cells, Font, Underline, Single	All
Ctrl+V	Paste	Edit, Paste	All
Ctrl W	Close	File, Close	Excel 97/2000 +
Ctrl+X	Cut	Edit, Cut	All
Ctrl+Y	Repeat	Edit, Repeat	All
Ctrl+Z	Undo	Edit, Undo	All
F11	New Chart	Insert, Chart	All
F12	Save As	File, Save As	All
Ctrl+:	Insert Current Time	None	All
Ctrl+;	Insert Current Date	None	All
Ctrl+"	Copy Value from Cell Above	Edit, Paste Special, Value	All
Ctrl+'	Copy Formula from Cell Above	Edit, Copy	All
Shift	Hold down shift for additional functions in Excel's menu	none	Excel 97/2000 +
Shift+F1	What's This?	Help, What's This?	All
Shift+F4	Find Next	Edit, Find, Find Next	All
Shift+F5	Find	Edit, Find, Find Next	All
Shift+F6	Previous Pane	None	All
Ctrl+Alt+F9	Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.	None	Excel 97/2000 +
Ctrl+Alt+Shift+F9	Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.	None	Excel 97/2000 +
Shift+F11	New worksheet	Insert, Worksheet	All
Shift+F12	Save	File, Save	All
Ctrl+F3	Define name	Insert, Names, Define	All
Ctrl+F5	XL, Restore window size	Restore	All
Ctrl+F6	Next workbook window	Window, ...	All
Shift+Ctrl+F6	Previous workbook window	Window, ...	All
Ctrl+F7	Move window	XL, Move	All
Ctrl+F9	Minimize workbook	XL, Minimize	All
Ctrl+F11	Inset 4.0 Macro sheet	None in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro	All
Ctrl+F12	File Open	File, Open	All
Alt+F1	Insert Chart	Insert, Chart...	All
Alt+F2	Save As	File, Save As	All
Alt+F8	Macro dialog box	Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versions	Excel 97/2000 +
Ctrl+Shift+F3	Create name by using names of row and column labels	Insert, Name, Create	All
Ctrl+Shift+F6	Previous Window	Window, ...	All
Ctrl+Shift+F12	Print	File, Print	All
Alt+Shift+F1	New worksheet	Insert, Worksheet	All
Alt+Shift+F2	Save	File, Save	All
Alt+=	AutoSum	No direct equivalent	All
Ctrl+`	Toggle Value/Formula display	Tools, Options, View, Formulas	All
Ctrl+Shift+A	Insert argument names into formula	No direct equivalent	All
Alt+Down arrow	Display AutoComplete list	None	Excel 95
Alt+'	Format Style dialog box	Format, Style	All
Ctrl+Shift+~	General format	Format, Cells, Number, Category, General	All
Ctrl+Shift+!	Comma format	Format, Cells, Number, Category, Number	All
Ctrl+Shift+@	Time format	Format, Cells, Number, Category, Time	All
Ctrl+Shift+#	Date format	Format, Cells, Number, Category, Date	All
Ctrl+Shift+$	Currency format	Format, Cells, Number, Category, Currency	All
Ctrl+Shift+%	Percent format	Format, Cells, Number, Category, Percentage	All
Ctrl+Shift+^	Exponential format	Format, Cells, Number, Category,	All
Ctrl+Shift+&	Place outline border around selected cells	Format, Cells, Border	All
Ctrl+Shift+_	Remove outline border	Format, Cells, Border	All
Ctrl++	Insert	Insert, (Rows, Columns, or Cells) Depends on selection	All
Ctrl+-	Delete	Delete, (Rows, Columns, or Cells) Depends on selection	All
Ctrl+1	Format cells dialog box	Format, Cells	All
Ctrl+2	Bold	Format, Cells, Font, Font Style, Bold	All
Ctrl+3	Italic	Format, Cells, Font, Font Style, Italic	All
Ctrl+4	Underline	Format, Cells, Font, Font Style, Underline	All
Ctrl+5	Strikethrough	Format, Cells, Font, Effects, Strikethrough	All
Ctrl+6	Show/Hide objects	Tools, Options, View, Objects, Show All/Hide	All
Ctrl+7	Show/Hide Standard toolbar	View, Toolbars, Stardard	All
Ctrl+8	Toggle Outline symbols	None	All
Ctrl+9	Hide rows	Format, Row, Hide	All
Ctrl+0	Hide columns	Format, Column, Hide	All
Ctrl+Shift+(	Unhide rows	Format, Row, Unhide	All
Ctrl+Shift+)	Unhide columns	Format, Column, Unhide	All
Alt or F10	Activate the menu	None	All
Alt+Enter	Start a new line in the same cell.	None	Excel 97/2000 +
Ctrl+Enter	Fill the selected cell range with the current entry.	None	Excel 97/2000 +
Shift+Ctrl+F	Font Drop Down List	Format, Cells, Font	All
Shift+Ctrl+F+F	Font tab of Format Cell Dialog box	Format, Cells, Font	Before 97/2000
Shift+Ctrl+P	Point size Drop Down List	Format, Cells, Font	All
F1	Help	Help
F2	View Object Browser	View, Object Browser
F3	Find Next
F4	Properies Window	View, Properties Window
F5	Run Sub/Form or Run Macro	Run, Run Macro
F6	Switch Split Windows
F7	View Code Window	View, Code
F8	Step Into	Debug, Step Into
F9	Toggle Breakpoint	Debug, Toggle Breakpoint
F10	Activate Menu Bar
Shift+F2	View definition	View, Definition
Shift+F3	Find Previous
Shift+F7	View Object	View, Object
Shift+F8	Step Over	Debug, Step Over
Shift+F9	Quick Watch	Debug, Quick Watch
Shift+F10	Show Right Click Menu
Ctrl+F2	Focus To Object Box
Ctrl+F4	Close Window
Ctrl+F8	Run To Cursor	Debug, Run To Cursor
Ctrl+F10	Activate Menu Bar
Alt+F4	Close VBE	File, Close and Return to Microsoft Excel
Alt+F6	Switch Between Last 2 Windows
Alt+F11	Return To Application
Ctrl+Shift+F2	Go to last position	View, Last Position
Ctrl+Shift+F8	Step Out	Debug, Step Out
Ctrl+Shift+F9	Clear All Breakpoints	Debug, Clear All Breakpoints
Insert	Toggle Insert Mode
Delete	Delete	Edit, Clear
Home	Move to beginning of line
End	Move to end of line
Page Up	Page Up
Page Down	Page Down
Left Arrow	Left
Right Arrow	Right
Up Arrow	Up
Down Arrow	Down
Tab	Indent	Edit, Indent
Enter	New Line
BackSpace	Delete Prev Char
Shift+Insert	Paste	Edit, Paste
Shift+Home	Select To Start Of Line
Shift+End	Select To End Of Line
Shift+Page Up	Select To Top Of Module
Shift+Page Down	Select To End Of Module
Shift+Left Arrow	Extend Selection Left 1 Char
Shift+Right Arrow	Extend Selection Right 1 Char
Shift+Up Arrow	Extend Selection Up
Shift+Down Arrow	Extend Selection Down
Shift+Tab	Outdent	Edit, Outdent
Alt+Spacebar	System Menu
Alt+Tab	Cycle Applications
Alt+BackSpace	Undo
Ctrl+A	Select All	Edit, Select All
Ctrl+C	Copy	Edit, Copy
Ctrl+E	Export Module	File, Export File
Ctrl+F	Find	Edit, Find…
Ctrl+G	Immediate Window	View, Immediate Window
Ctrl+H	Replace	Edit, Replace…
Ctrl+I	Turn On Quick Info	Edit, Quikc Info
Ctrl+J	List Properties/Methods	Edit, List Properties/Methods
Ctrl+L	Show Call Stack
Ctrl+M	Import File	File, Import File
Ctrl+N	New Line
Ctrl+P	Print	File, Print
Ctrl+R	Project Explorer	View, Project Explorer
Ctrl+S	Save	File, Save
Ctrl+T	Show Available Components	Insert, Components...
Ctrl+V	Paste	Edit, Paste
Ctrl+X	Cut	Edit, Cut
Ctrl+Y	Cut Entire Line
Ctrl+Z	Undo	Edit, Undo
Ctrl+Insert	Copy	Edit, Copy
Ctrl+Delete	Delete To End Of Word
Ctrl+Home	Top Of Module
Ctrl+End	End Of Module
Ctrl+Page Up	Top Of Current Procedure
Ctrl+Page Down	End Of Current Procedure
Ctrl+Left Arrow	Move one word to left
Ctrl+Right Arrow	Move one word to right
Ctrl+Up Arrow	Previous Procedure
Ctrl+Down Arrow	Next Procedure
Ctrl+Spacebar	Complete Word	Edit, Complete Word
Ctrl+Tab	Cycle Windows
Ctrl+BackSpace	Delete To Start Of Word
Ctrl+Shift+I	Parameter Info	Edit, Parameter Info
Ctrl+Shift+J	List Constants	Edit, List Constants
F2	Edit the selected cell.		Excel 2007
F3	After a name has been created F3 will paste names.		Excel 2007
F4	Repeat last action. For example, if you changed the color of text in another cell pressing F4 will change the text in cell to the same color.		Excel 2007
F5	Go to a specific cell. For example, C6.		Excel 2007
F7	Spell check selected text or document.		Excel 2007
F11	Create chart from selected data.		Excel 2007
Ctrl + Shift + ;	Enter the current time.		Excel 2007
Ctrl + ;	Enter the current date.		Excel 2007
Alt + Shift + F1	Insert New Worksheet.		Excel 2007
Alt + Enter	While typing text in a cell pressing Alt + Enter will move to the next line allowing for multiple lines of text in one cell.		Excel 2007
Shift + F3	Open the Excel formula window.		Excel 2007
Shift + F5	Bring up search box.		Excel 2007
Ctrl + 1	Open the Format Cells window.		Excel 2007
Ctrl + A	Select all contents of the worksheet.		Excel 2007
Ctrl + B	Bold highlighted selection.		Excel 2007
Ctrl + I	Italic highlighted selection.		Excel 2007
Ctrl + K	Insert link.		Excel 2007
Ctrl + S	Save the open worksheet.		Excel 2007
Ctrl + U	Underline highlighted selection.		Excel 2007
Ctrl + 1	Change the format of selected cells.		Excel 2007
Ctrl + 5	Strikethrough highlighted selection.		Excel 2007
Ctrl + P	Bring up the print dialog box to begin printing.		Excel 2007
Ctrl + Z	Undo last action.		Excel 2007
Ctrl + F3	Open Excel Name Manager.		Excel 2007
Ctrl + F9	Minimize current window.		Excel 2007
Ctrl + F10	Maximize currently selected window.		Excel 2007
Ctrl + F6	Switch between open workbooks or windows.		Excel 2007
Ctrl + Page up	Move between Excel work sheets in the same Excel document.		Excel 2007
Ctrl + Page down	Move between Excel work sheets in the same Excel document.		Excel 2007
Ctrl + Tab	Move between Two or more open Excel files.		Excel 2007
Alt + =	Create a formula to sum all of the above cells		Excel 2007
Ctrl + '	Insert the value of the above cell into cell currently selected.		Excel 2007
Ctrl + Shift + !	Format number in comma format.		Excel 2007
Ctrl + Shift + $	Format number in currency format.		Excel 2007
Ctrl + Shift + #	Format number in date format.		Excel 2007
Ctrl + Shift + %	Format number in percentage format.		Excel 2007
Ctrl + Shift + ^	Format number in scientific format.		Excel 2007
Ctrl + Shift + @	Format number in time format.		Excel 2007
Ctrl + Arrow key	Move to next section of text.		Excel 2007
Ctrl + Space	Select entire column.		Excel 2007
Shift + Space	Select entire row.		Excel 2007
Ctrl + -	Delete the slected column or row.		Excel 2007
Ctrl + Shift + =	Insert a new column or row.		Excel 2007
Ctrl + Home	Move to cell A1.		Excel 2007
Ctrl + ~	Switch between showing Excel formulas or their values in cells.		Excel 2007
CTRL+PgUp	Switches between worksheet tabs, from left-to-right.		Excel 2007
CTRL+PgDn	Switches between worksheet tabs, from right-to-left.		Excel 2007
CTRL+SHIFT+(	Unhides any hidden rows within the selection.		Excel 2007
CTRL+SHIFT+)	Unhides any hidden columns within the selection.		Excel 2007
CTRL+SHIFT+&	Applies the outline border to the selected cells.		Excel 2007
CTRL+SHIFT_	Removes the outline border from the selected cells.		Excel 2007
CTRL+SHIFT+~	Applies the General number format.		Excel 2007
CTRL+SHIFT+$	Applies the Currency format with two decimal places (negative numbers in parentheses).		Excel 2007
CTRL+SHIFT+%	Applies the Percentage format with no decimal places.		Excel 2007
CTRL+SHIFT+^	Applies the Exponential number format with two decimal places.		Excel 2007
CTRL+SHIFT+#	Applies the Date format with the day, month, and year.		Excel 2007
CTRL+SHIFT+@	Applies the Time format with the hour and minute, and AM or PM.		Excel 2007
CTRL+SHIFT+!	Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.		Excel 2007
CTRL+SHIFT+*	Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).		Excel 2007
CTRL+SHIFT+:	Enters the current time.		Excel 2007
CTRL+SHIFT+"	Copies the value from the cell above the active cell into the cell or the Formula Bar.		Excel 2007
CTRL+SHIFT+Plus (+)	Displays the Insert dialog box to insert blank cells.		Excel 2007
CTRL+Minus (-)	Displays the Delete dialog box to delete the selected cells.		Excel 2007
CTRL+;	Enters the current date.		Excel 2007
CTRL+`	Alternates between displaying cell values and displaying formulas in the worksheet.		Excel 2007
CTRL+'	Copies a formula from the cell above the active cell into the cell or the Formula Bar.		Excel 2007
CTRL+1	Displays the Format Cells dialog box.		Excel 2007
CTRL+2	Applies or removes bold formatting.		Excel 2007
CTRL+3	Applies or removes italic formatting.		Excel 2007
CTRL+4	Applies or removes underlining.		Excel 2007
CTRL+5	Applies or removes strikethrough.		Excel 2007
CTRL+6	Alternates between hiding objects, displaying objects, and displaying placeholders for objects.		Excel 2007
CTRL+8	Displays or hides the outline symbols.		Excel 2007
CTRL+9	Hides the selected rows.		Excel 2007
CTRL+0	Hides the selected columns.		Excel 2007
CTRL+A	Selects the entire worksheet.		Excel 2007
CTRL+B	Applies or removes bold formatting.		Excel 2007
CTRL+C	Copies the selected cells.		Excel 2007
CTRL+D	Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.		Excel 2007
CTRL+F	Displays the Find and Replace dialog box, with the Find tab selected.		Excel 2007
CTRL+G	Displays the Go To dialog box.		Excel 2007
CTRL+H	Displays the Find and Replace dialog box, with the Replace tab selected.		Excel 2007
CTRL+I	Applies or removes italic formatting.		Excel 2007
CTRL+K	Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.		Excel 2007
CTRL+N	Creates a new, blank workbook.		Excel 2007
CTRL+O	Displays the Open dialog box to open or find a file.		Excel 2007
CTRL+P	Displays the Print dialog box.		Excel 2007
CTRL+R	Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.		Excel 2007
CTRL+S	Saves the active file with its current file name, location, and file format.		Excel 2007
CTRL+T	Displays the Create Table dialog box.		Excel 2007
CTRL+U	Applies or removes underlining.		Excel 2007
CTRL+V	Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.		Excel 2007
CTRL+W	Closes the selected workbook window.		Excel 2007
CTRL+X	Cuts the selected cells.		Excel 2007
CTRL+Y	Repeats the last command or action, if possible.		Excel 2007
CTRL+Z	Uses the Undo command to reverse the last command or to delete the last entry that you typed.		Excel 2007
F1	Displays the Microsoft Office Excel Help task pane.		Excel 2007
			Excel 2007
	CTRL+F1 displays or hides the Ribbon, a component of the Microsoft Office Fluent user interface.		Excel 2007
			Excel 2007
	ALT+F1 creates a chart of the data in the current range.		Excel 2007
			Excel 2007
	ALT+SHIFT+F1 inserts a new worksheet.		Excel 2007
F2	Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.		Excel 2007
			Excel 2007
	SHIFT+F2 adds or edits a cell comment.		Excel 2007
			Excel 2007
	CTRL+F2 displays the Print Preview window.		Excel 2007
F3	Displays the Paste Name dialog box.		Excel 2007
			Excel 2007
	SHIFT+F3 displays the Insert Function dialog box.		Excel 2007
F4	Repeats the last command or action, if possible.		Excel 2007
			Excel 2007
	When a cell reference or range is selected in a formula, F4 cycles through the various combinations of absolute and relative references.		Excel 2007
			Excel 2007
	CTRL+F4 closes the selected workbook window.		Excel 2007
F5	Displays the Go To dialog box.		Excel 2007
			Excel 2007
	CTRL+F5 restores the window size of the selected workbook window.		Excel 2007
F6	Switches between the worksheet, Ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), F6 includes the split panes when switching between panes and the Ribbon area.		Excel 2007
			Excel 2007
	SHIFT+F6 switches between the worksheet, Zoom controls, task pane, and Ribbon.		Excel 2007
			Excel 2007
	CTRL+F6 switches to the next workbook window when more than one workbook window is open.		Excel 2007
F7	Displays the Spelling dialog box to check spelling in the active worksheet or selected range.		Excel 2007
			Excel 2007
	CTRL+F7 performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ENTER, or ESC to cancel.		Excel 2007
F8	Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.		Excel 2007
			Excel 2007
	SHIFT+F8 enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.		Excel 2007
			Excel 2007
	CTRL+F8 performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.		Excel 2007
			Excel 2007
	ALT+F8 displays the Macro dialog box to create, run, edit, or delete a macro.		Excel 2007
F9	Calculates all worksheets in all open workbooks.		Excel 2007
			Excel 2007
	SHIFT+F9 calculates the active worksheet.		Excel 2007
			Excel 2007
	CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.		Excel 2007
			Excel 2007
	CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.		Excel 2007
			Excel 2007
	CTRL+F9 minimizes a workbook window to an icon.		Excel 2007
F10	Turns key tips on or off.		Excel 2007
			Excel 2007
	SHIFT+F10 displays the shortcut menu for a selected item.		Excel 2007
			Excel 2007
	ALT+SHIFT+F10 displays the menu or message for a smart tag. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message.		Excel 2007
			Excel 2007
	CTRL+F10 maximizes or restores the selected workbook window.		Excel 2007
F11	Creates a chart of the data in the current range.		Excel 2007
			Excel 2007
	SHIFT+F11 inserts a new worksheet.		Excel 2007
			Excel 2007
	ALT+F11 opens the Microsoft Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA).		Excel 2007
F12	Displays the Save As dialog box.		Excel 2007
ARROW KEYS	Move one cell up, down, left, or right in a worksheet.		Excel 2007
			Excel 2007
	CTRL+ARROW KEY moves to the edge of the current data region in a worksheet.		Excel 2007
			Excel 2007
	SHIFT+ARROW KEY extends the selection of cells by one cell.		Excel 2007
			Excel 2007
	CTRL+SHIFT+ARROW KEY extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.		Excel 2007
			Excel 2007
	LEFT ARROW or RIGHT ARROW selects the tab to the left or right when the Ribbon is selected. When a submenu is open or selected, these arrow keys switch between the main menu and the submenu. When a Ribbon tab is selected, these keys navigate the tab buttons.		Excel 2007
			Excel 2007
	DOWN ARROW or UP ARROW selects the next or previous command when a menu or submenu is open. When a Ribbon tab is selected, these keys navigate up or down the tab group.		Excel 2007
			Excel 2007
	In a dialog box, arrow keys move between options in an open drop-down list, or between options in a group of options.		Excel 2007
			Excel 2007
	DOWN ARROW or ALT+DOWN ARROW opens a selected drop-down list.		Excel 2007
BACKSPACE	Deletes one character to the left in the Formula Bar.		Excel 2007
			Excel 2007
	Also clears the content of the active cell.		Excel 2007
			Excel 2007
	In cell editing mode, it deletes the character to the left of the insertion point.		Excel 2007
DELETE	Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments.		Excel 2007
			Excel 2007
	In cell editing mode, it deletes the character to the right of the insertion point.		Excel 2007
END	Moves to the cell in the lower-right corner of the window when SCROLL LOCK is turned on.		Excel 2007
			Excel 2007
	Also selects the last command on the menu when a menu or submenu is visible.		Excel 2007
			Excel 2007
	CTRL+END moves to the last cell on a worksheet, in the lowest used row of the rightmost used column. If the cursor is in the formula bar, CTRL+END moves the cursor to the end of the text.		Excel 2007
			Excel 2007
	CTRL+SHIFT+END extends the selection of cells to the last used cell on the worksheet (lower-right corner). If the cursor is in the formula bar, CTRL+SHIFT+END selects all text in the formula bar from the cursor position to the end—this does not affect the height of the formula bar.		Excel 2007
ENTER	Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by default).		Excel 2007
			Excel 2007
	In a data form, it moves to the first field in the next record.		Excel 2007
			Excel 2007
	Opens a selected menu (press F10 to activate the menu bar) or performs the action for a selected command.		Excel 2007
			Excel 2007
	In a dialog box, it performs the action for the default command button in the dialog box (the button with the bold outline, often the OK button).		Excel 2007
			Excel 2007
	ALT+ENTER starts a new line in the same cell.		Excel 2007
			Excel 2007
	CTRL+ENTER fills the selected cell range with the current entry.		Excel 2007
			Excel 2007
	SHIFT+ENTER completes a cell entry and selects the cell above.		Excel 2007
ESC	Cancels an entry in the cell or Formula Bar.		Excel 2007
			Excel 2007
	Closes an open menu or submenu, dialog box, or message window.		Excel 2007
			Excel 2007
	It also closes full screen mode when this mode has been applied, and returns to normal screen mode to display the Ribbon and status bar again.		Excel 2007
HOME	Moves to the beginning of a row in a worksheet.		Excel 2007
			Excel 2007
	Moves to the cell in the upper-left corner of the window when SCROLL LOCK is turned on.		Excel 2007
			Excel 2007
	Selects the first command on the menu when a menu or submenu is visible.		Excel 2007
			Excel 2007
	CTRL+HOME moves to the beginning of a worksheet.		Excel 2007
			Excel 2007
	CTRL+SHIFT+HOME extends the selection of cells to the beginning of the worksheet.		Excel 2007
PAGE DOWN	Moves one screen down in a worksheet.		Excel 2007
			Excel 2007
	ALT+PAGE DOWN moves one screen to the right in a worksheet.		Excel 2007
			Excel 2007
	CTRL+PAGE DOWN moves to the next sheet in a workbook.		Excel 2007
			Excel 2007
	CTRL+SHIFT+PAGE DOWN selects the current and next sheet in a workbook.		Excel 2007
PAGE UP	Moves one screen up in a worksheet.		Excel 2007
			Excel 2007
	ALT+PAGE UP moves one screen to the left in a worksheet.		Excel 2007
			Excel 2007
	CTRL+PAGE UP moves to the previous sheet in a workbook.		Excel 2007
			Excel 2007
	CTRL+SHIFT+PAGE UP selects the current and previous sheet in a workbook.		Excel 2007
SPACEBAR	In a dialog box, performs the action for the selected button, or selects or clears a check box.		Excel 2007
			Excel 2007
	CTRL+SPACEBAR selects an entire column in a worksheet.		Excel 2007
			Excel 2007
	SHIFT+SPACEBAR selects an entire row in a worksheet.		Excel 2007
			Excel 2007
	CTRL+SHIFT+SPACEBAR selects the entire worksheet.		Excel 2007
			Excel 2007
	If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. Pressing CTRL+SHIFT+SPACEBAR a second time selects the current region and its summary rows. Pressing CTRL+SHIFT+SPACEBAR a third time selects the entire worksheet.		Excel 2007
	When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet.		Excel 2007
			Excel 2007
	ALT+SPACEBAR displays the Control menu for the Microsoft Office Excel window.		Excel 2007
TAB	Moves one cell to the right in a worksheet.		Excel 2007
			Excel 2007
	Moves between unlocked cells in a protected worksheet.		Excel 2007
			Excel 2007
	Moves to the next option or option group in a dialog box.		Excel 2007
			Excel 2007
	SHIFT+TAB moves to the previous cell in a worksheet or the previous option in a dialog box.		Excel 2007
			Excel 2007
	CTRL+TAB switches to the next tab in dialog box.		Excel 2007
			Excel 2007
	CTRL+SHIFT+TAB switches to the previous tab in a dialog box.		Excel 2007
Ctrl+PgDn	Switches between worksheet tabs, from left-to-right.		Excel 2013
Ctrl+PgUp	Switches between worksheet tabs, from right-to-left.		Excel 2013
Ctrl+Shift+&	Applies the outline border to the selected cells.		Excel 2013
Ctrl+Shift_	Removes the outline border from the selected cells.		Excel 2013
Ctrl+Shift+~	Applies the General number format.		Excel 2013
Ctrl+Shift+$	Applies the Currency format with two decimal places (negative numbers in parentheses).		Excel 2013
Ctrl+Shift+%	Applies the Percentage format with no decimal places.		Excel 2013
Ctrl+Shift+^	Applies the Scientific number format with two decimal places.		Excel 2013
Ctrl+Shift+#	Applies the Date format with the day, month, and year.		Excel 2013
Ctrl+Shift+@	Applies the Time format with the hour and minute, and AM or PM.		Excel 2013
Ctrl+Shift+!	Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.		Excel 2013
Ctrl+Shift+:	Enters the current time.		Excel 2013
Ctrl+Shift+"	Copies the value from the cell above the active cell into the cell or the Formula Bar.		Excel 2013
Ctrl+Shift+Plus (+)	Displays the Insert dialog box to insert blank cells.		Excel 2013
Ctrl+Minus (-)	Displays the Delete dialog box to delete the selected cells.		Excel 2013
Ctrl+;	Enters the current date.		Excel 2013
Ctrl+`	Alternates between displaying cell values and displaying formulas in the worksheet.		Excel 2013
Ctrl+'	Copies a formula from the cell above the active cell into the cell or the Formula Bar.		Excel 2013
Ctrl+1	Displays the Format Cells dialog box.		Excel 2013
Ctrl+2	Applies or removes bold formatting.		Excel 2013
Ctrl+3	Applies or removes italic formatting.		Excel 2013
Ctrl+4	Applies or removes underlining.		Excel 2013
Ctrl+5	Applies or removes strikethrough.		Excel 2013
Ctrl+6	Alternates between hiding and displaying objects.		Excel 2013
Ctrl+8	Displays or hides the outline symbols.		Excel 2013
Ctrl+9	Hides the selected rows.		Excel 2013
Ctrl+0	Hides the selected columns.		Excel 2013
Ctrl+A	Selects the entire worksheet.		Excel 2013
			Excel 2013
	If the worksheet contains data, Ctrl+A selects the current region. Pressing Ctrl+A a second time selects the entire worksheet.		Excel 2013
			Excel 2013
	When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.		Excel 2013
			Excel 2013
	Ctrl+Shift+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.		Excel 2013
Ctrl+B	Applies or removes bold formatting.		Excel 2013
Ctrl+C	Copies the selected cells.		Excel 2013
Ctrl+D	Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.		Excel 2013
Ctrl+E	Adds more values to the active column by using data surrounding that column.		Excel 2013
Ctrl+F	Displays the Find and Replace dialog box, with the Find tab selected.		Excel 2013
			Excel 2013
	Shift+F5 also displays this tab, while Shift+F4 repeats the last Find action.		Excel 2013
			Excel 2013
	Ctrl+Shift+F opens the Format Cells dialog box with the Font tab selected.		Excel 2013
Ctrl+G	Displays the Go To dialog box.		Excel 2013
			Excel 2013
	F5 also displays this dialog box.		Excel 2013
Ctrl+H	Displays the Find and Replace dialog box, with the Replace tab selected.		Excel 2013
Ctrl+I	Applies or removes italic formatting.		Excel 2013
Ctrl+K	Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.		Excel 2013
Ctrl+L	Displays the Create Table dialog box.		Excel 2013
Ctrl+N	Creates a new, blank workbook.		Excel 2013
Ctrl+O	Displays the Open dialog box to open or find a file.		Excel 2013
			Excel 2013
	Ctrl+Shift+O selects all cells that contain comments.		Excel 2013
Ctrl+P	Displays the Print tab in Microsoft Office Backstage view.		Excel 2013
			Excel 2013
	Ctrl+Shift+P opens the Format Cells dialog box with the Font tab selected.		Excel 2013
Ctrl+Q	Displays the Quick Analysis options for your data when you have cells that contain that data selected.		Excel 2013
Ctrl+R	Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.		Excel 2013
Ctrl+S	Saves the active file with its current file name, location, and file format.		Excel 2013
Ctrl+T	Displays the Create Table dialog box.		Excel 2013
Ctrl+U	Applies or removes underlining.		Excel 2013
			Excel 2013
	Ctrl+Shift+U switches between expanding and collapsing of the formula bar.		Excel 2013
Ctrl+V	Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.		Excel 2013
			Excel 2013
	Ctrl+Alt+V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.		Excel 2013
Ctrl+W	Closes the selected workbook window.		Excel 2013
Ctrl+X	Cuts the selected cells.		Excel 2013
Ctrl+Y	Repeats the last command or action, if possible.		Excel 2013
Ctrl+Z	Uses the Undo command to reverse the last command or to delete the last entry that you typed.		Excel 2013
F1	Displays the Excel Help task pane.		Excel 2013
			Excel 2013
	Ctrl+F1 displays or hides the ribbon.		Excel 2013
			Excel 2013
	Alt+F1 creates an embedded chart of the data in the current range.		Excel 2013
			Excel 2013
	Alt+Shift+F1 inserts a new worksheet.		Excel 2013
F2	Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.		Excel 2013
			Excel 2013
	Shift+F2 adds or edits a cell comment.		Excel 2013
			Excel 2013
	Ctrl+F2 displays the print preview area on the Print tab in the Backstage view.		Excel 2013
F3	Displays the Paste Name dialog box. Available only if names have been defined in the workbook (Formulas tab, Defined Names group, Define Name).		Excel 2013
			Excel 2013
	Shift+F3 displays the Insert Function dialog box.		Excel 2013
F4	Repeats the last command or action, if possible.		Excel 2013
			Excel 2013
	When a cell reference or range is selected in a formula, F4 cycles through all the various combinations of absolute and relative references.		Excel 2013
			Excel 2013
	Ctrl+F4 closes the selected workbook window.		Excel 2013
			Excel 2013
	Alt+F4 closes Excel.		Excel 2013
F5	Displays the Go To dialog box.		Excel 2013
			Excel 2013
	Ctrl+F5 restores the window size of the selected workbook window.		Excel 2013
F6	Switches between the worksheet, ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), F6 includes the split panes when switching between panes and the ribbon area.		Excel 2013
			Excel 2013
	Shift+F6 switches between the worksheet, Zoom controls, task pane, and ribbon.		Excel 2013
			Excel 2013
	Ctrl+F6 switches to the next workbook window when more than one workbook window is open.		Excel 2013
F7	Displays the Spelling dialog box to check spelling in the active worksheet or selected range.		Excel 2013
			Excel 2013
	Ctrl+F7 performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press Enter, or Esc to cancel.		Excel 2013
F8	Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.		Excel 2013
			Excel 2013
	Shift+F8 enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.		Excel 2013
			Excel 2013
	Ctrl+F8 performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.		Excel 2013
			Excel 2013
	Alt+F8 displays the Macro dialog box to create, run, edit, or delete a macro.		Excel 2013
F9	Calculates all worksheets in all open workbooks.		Excel 2013
			Excel 2013
	Shift+F9 calculates the active worksheet.		Excel 2013
			Excel 2013
	Ctrl+Alt+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.		Excel 2013
			Excel 2013
	Ctrl+Alt+Shift+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.		Excel 2013
			Excel 2013
	Ctrl+F9 minimizes a workbook window to an icon.		Excel 2013
F10	Turns key tips on or off. (Pressing Alt does the same thing.)		Excel 2013
			Excel 2013
	Shift+F10 displays the shortcut menu for a selected item.		Excel 2013
			Excel 2013
	Alt+Shift+F10 displays the menu or message for an Error Checking button.		Excel 2013
			Excel 2013
	Ctrl+F10 maximizes or restores the selected workbook window.		Excel 2013
F11	Creates a chart of the data in the current range in a separate Chart sheet.		Excel 2013
			Excel 2013
	Shift+F11 inserts a new worksheet.		Excel 2013
			Excel 2013
	Alt+F11 opens the Microsoft Visual Basic For Applications Editor, in which you can create a macro by using Visual Basic for Applications (VBA).		Excel 2013
F12	Displays the Save As dialog box.		Excel 2013
Alt	Displays the Key Tips (new shortcuts) on the ribbon.		Excel 2013
			Excel 2013
	For example,		Excel 2013
			Excel 2013
	Alt, W, P switches the worksheet to Page Layout view.		Excel 2013
			Excel 2013
	Alt, W, L switches the worksheet to Normal view.		Excel 2013
			Excel 2013
	Alt, W, I switches the worksheet to Page Break Preview view.		Excel 2013
Arrow Keys	Move one cell up, down, left, or right in a worksheet.		Excel 2013
			Excel 2013
	Ctrl+Arrow Key moves to the edge of the current data region in a worksheet.		Excel 2013
			Excel 2013
	Shift+Arrow Key extends the selection of cells by one cell.		Excel 2013
			Excel 2013
	Ctrl+Shift+Arrow Key extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.		Excel 2013
			Excel 2013
	Left Arrow or Right Arrow selects the tab to the left or right when the ribbon is selected. When a submenu is open or selected, these arrow keys switch between the main menu and the submenu. When a ribbon tab is selected, these keys navigate the tab buttons.		Excel 2013
			Excel 2013
	Down Arrow or Up Arrow selects the next or previous command when a menu or submenu is open. When a ribbon tab is selected, these keys navigate up or down the tab group.		Excel 2013
			Excel 2013
	In a dialog box, arrow keys move between options in an open drop-down list, or between options in a group of options.		Excel 2013
			Excel 2013
	Down Arrow or Alt+Down Arrow opens a selected drop-down list.		Excel 2013
Backspace	Deletes one character to the left in the Formula Bar.		Excel 2013
			Excel 2013
	Also clears the content of the active cell.		Excel 2013
			Excel 2013
	In cell editing mode, it deletes the character to the left of the insertion point.		Excel 2013
Delete	Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments.		Excel 2013
			Excel 2013
	In cell editing mode, it deletes the character to the right of the insertion point.		Excel 2013
End	End turns End mode on or off. In End mode, you can press an arrow key to move to the next nonblank cell in the same column or row as the active cell. End mode turns off automatically after pressing the arrow key. Make sure to press End again before pressing the next arrow key. End mode is shown in the status bar when it is on.		Excel 2013
			Excel 2013
	If the cells are blank, pressing End followed by an arrow key moves to the last cell in the row or column.		Excel 2013
			Excel 2013
	End also selects the last command on the menu when a menu or submenu is visible.		Excel 2013
			Excel 2013
	Ctrl+End moves to the last cell on a worksheet, to the lowest used row of the rightmost used column. If the cursor is in the formula bar, Ctrl+End moves the cursor to the end of the text.		Excel 2013
			Excel 2013
	Ctrl+Shift+End extends the selection of cells to the last used cell on the worksheet (lower-right corner). If the cursor is in the formula bar, Ctrl+Shift+End selects all text in the formula bar from the cursor position to the end—this does not affect the height of the formula bar.		Excel 2013
Enter	Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by default).		Excel 2013
			Excel 2013
	In a data form, it moves to the first field in the next record.		Excel 2013
			Excel 2013
	Opens a selected menu (press F10 to activate the menu bar) or performs the action for a selected command.		Excel 2013
			Excel 2013
	In a dialog box, it performs the action for the default command button in the dialog box (the button with the bold outline, often the OK button).		Excel 2013
			Excel 2013
	Alt+Enter starts a new line in the same cell.		Excel 2013
			Excel 2013
	Ctrl+Enter fills the selected cell range with the current entry.		Excel 2013
			Excel 2013
	Shift+Enter completes a cell entry and selects the cell above.		Excel 2013
Esc	Cancels an entry in the cell or Formula Bar.		Excel 2013
			Excel 2013
	Closes an open menu or submenu, dialog box, or message window.		Excel 2013
			Excel 2013
	It also closes full screen mode when this mode has been applied, and returns to normal screen mode to display the ribbon and status bar again.		Excel 2013
Home	Moves to the beginning of a row in a worksheet.		Excel 2013
			Excel 2013
	Moves to the cell in the upper-left corner of the window when Scroll Lock is turned on.		Excel 2013
			Excel 2013
	Selects the first command on the menu when a menu or submenu is visible.		Excel 2013
			Excel 2013
	Ctrl+Home moves to the beginning of a worksheet.		Excel 2013
			Excel 2013
	Ctrl+Shift+Home extends the selection of cells to the beginning of the worksheet.		Excel 2013
Page Down	Moves one screen down in a worksheet.		Excel 2013
			Excel 2013
	Alt+Page Down moves one screen to the right in a worksheet.		Excel 2013
			Excel 2013
	Ctrl+Page Down moves to the next sheet in a workbook.		Excel 2013
			Excel 2013
	Ctrl+Shift+Page Down selects the current and next sheet in a workbook.		Excel 2013
Page Up	Moves one screen up in a worksheet.		Excel 2013
			Excel 2013
	Alt+Page Up moves one screen to the left in a worksheet.		Excel 2013
			Excel 2013
	Ctrl+Page Up moves to the previous sheet in a workbook.		Excel 2013
			Excel 2013
	Ctrl+Shift+Page Up selects the current and previous sheet in a workbook.		Excel 2013
Spacebar	In a dialog box, performs the action for the selected button, or selects or clears a check box.		Excel 2013
			Excel 2013
	Ctrl+Spacebar selects an entire column in a worksheet.		Excel 2013
			Excel 2013
	Shift+Spacebar selects an entire row in a worksheet.		Excel 2013
			Excel 2013
	Ctrl+Shift+Space bar selects the entire worksheet.		Excel 2013
			Excel 2013
	If the worksheet contains data, Ctrl+Shift+Spacebar selects the current region. Pressing Ctrl+Shift+Spacebar a second time selects the current region and its summary rows. Pressing Ctrl+Shift+Spacebar a third time selects the entire worksheet.		Excel 2013
	When an object is selected, Ctrl+Shift+Space-bar selects all objects on a worksheet.		Excel 2013
			Excel 2013
	Alt+Space-bar displays the Control menu for the Excel window.		Excel 2013
Tab	Moves one cell to the right in a worksheet.		Excel 2013
			Excel 2013
	Moves between unlocked cells in a protected worksheet.		Excel 2013
			Excel 2013
	Moves to the next option or option group in a dialog box.		Excel 2013
			Excel 2013
	Shift+Tab moves to the previous cell in a worksheet or the previous option in a dialog box.		Excel 2013
			Excel 2013
	Ctrl+Tab switches to the next tab in dialog box.		Excel 2013
			Excel 2013
	Ctrl+Shift+Tab switches to the previous tab in a dialog box.		Excel 2013