CK: Excel Shortcut Keys

Excel Shortcut Keys

Shortcut Key	Action
CTRL+A	Selects the entire worksheet.
CTRL+B	Applies or removes bold formatting.
CTRL+C	Copies the selected cells.
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.
CTRL+F	Displays the Find dialog box.
CTRL+G	Displays the Go To dialog box.
CTRL+H	Displays the Find and Replace dialog box.
CTRL+I	Applies or removes italic formatting.
CTRL+K	Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
CTRL+L	Displays the Create List dialog box.
CTRL+N	Creates a new blank file.
CTRL+O	Displays the Open dialog box to open or find a file.
CTRL+P	Displays the Print dialog box.
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.
CTRL+S	Saves the active file with its current file name, location, and file format.
CTRL+U	Applies or removes underlining.
CTRL+V	Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you cut or copied an object, text, or cell contents.
CTRL+W	Closes the selected workbook window.
CTRL+X	Cuts the selected cells.
CTRL+Y	Repeats the last command or action, if possible.
CTRL+Z	Uses the Undo command to reverse the last command or to delete the last entry you typed.
CTRL+1	Displays the Format Cells dialog box.
CTRL+2	Applies or removes bold formatting.
CTRL+3	Applies or removes italic formatting.
CTRL+4	Applies or removes underlining.
CTRL+5	Applies or removes strikethrough.
CTRL+6	Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
CTRL+7	Displays or hides the Standard toolbar.
CTRL+8	Displays or hides the outline symbols.
CTRL+9	Hides the selected rows.
CTRL+0	Hides the selected columns.
CTRL+(	Unhides any hidden rows within the selection.
CTRL+)	Unhides any hidden columns within the selection.
CTRL+&	Applies the outline border to the selected cells.
CTRL+_	Removes the outline border from the selected cells.
CTRL+~	Applies the General number format.
CTRL+$	Applies the Currency format with two decimal places (negative numbers in parentheses).
CTRL+%	Applies the Percentage format with no decimal places.
CTRL+^	Applies the Exponential number format with two decimal places.
CTRL+#	Applies the Date format with the day, month, and year.
CTRL+@	Applies the Time format with the hour and minute, and AM or PM.
CTRL+!	Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+*	Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).
CTRL+:	Enters the current time.
CTRL+;	Enters the current date.
CTRL+`	Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+'	Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+"	Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL++	Displays the Insert dialog box to insert blank cells.
CTRL + ;	Enter the current date.
CTRL + -	Delete the slected column or row.
F1	Help
F2	Edit
F3	Paste Name
F4	Repeat last action
F4	While typing a formula, switch between absolute/relative refs
F5	Goto
F6	Next Pane
F7	Spell check
F8	Extend mode
F9	Recalculate all workbooks
F10	Activate Menubar
F11	New Chart
F12	Save As
CTRL + Page up	Move between Excel work sheets in the same Excel document.
CTRL + Page down	Move between Excel work sheets in the same Excel document.
CTRL + Tab	Move between Two or more open Excel files.
CTRL + Arrow key	Move to next section of text.
CTRL + Space	Select entire column.
CTRL + Home	Move to cell A1.
CTRL + Shift + =	Insert a new column or row.
CTRL + Shift + ;	Enter the current time.
CTRL + Shift + !	Format number in comma format.
CTRL + Shift + $	Format number in currency format.
CTRL + Shift + #	Format number in date format.
CTRL + Shift + %	Format number in percentage format.
CTRL + Shift + ^	Format number in scientific format.
CTRL + Shift + @	Format number in time format.
CTRL+Shift+F3	Create name by using names of row and column labels
CTRL+Shift+F6	Previous Window
CTRL+Shift+F12	Print
Alt + =	Create a formula to sum all of the above cells
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.
Alt + Shift + F1	Insert New Worksheet.
Shift+F1	What’s This?
Shift+F2	Edit cell comment
Shift+F3	Paste function into formula
Shift+F4	Find Next
Shift+F5	Find
Shift+F6	Previous Pane
Shift+F8	Add to selection
Shift+F9	Calculate active worksheet
Shift+F10	Display shortcut menu
Shift+F11	New worksheet
Shift+F12	Save
Shift + Space	Select entire row.
Alt+F1	Insert Chart
Alt+F2	Save As
Alt+F4	Exit
Alt+F8	Macro dialog box
Alt+F11	Visual Basic Editor
Alt+Shift+F1	New worksheet
Alt+Shift+F2	Save
CTRL+Alt+F9	Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
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.