250+ Excel Shortcuts

Action	Shortcut	Toggle Available	Category
Subtotal	Alt + A + B		Arithmetic Operations
Insert Function	Shift + F3		Arithmetic Operations
Autosum of a row or column	Alt + =		Arithmetical Operations
Average of a series of numbers	Alt + M + U + A		Arithmetical Operations
Count of a series of numbers	Alt + M + U + C		Arithmetical Operations
Max of a series of numbers	Alt + M + U + M		Arithmetical Operations
Min of a series of numbers	Alt + M + U + I		Arithmetical Operations
Show/Hide Gridlines	Alt + W + VG	Yes	Borders and Outlines
Add border outline	Ctrl + Shift + &		Borders and Outlines
Remove borders	Ctrl + Shift + _		Borders and Outlines
Add bottom borders	Alt + H + B + O		Borders and Outlines
Add top borders	Alt + H + B + P		Borders and Outlines
Add left borders	Alt + H + B + L		Borders and Outlines
Add right borders	Alt + H + B + R		Borders and Outlines
Remove Borders	Alt + H + B + N		Borders and Outlines
Add all borders	Alt + H + B + A		Borders and Outlines
Add outside borders	Alt + H + B + S		Borders and Outlines
Add thick box border	Alt + H + B + T		Borders and Outlines
Add bottom double border	Alt + H + B + B		Borders and Outlines
Add thick bottom border	Alt + H + B + H		Borders and Outlines
Add top and bottom border	Alt + H + B + D		Borders and Outlines
Add top and thick bottom border	Alt + H + B + C		Borders and Outlines
Add top and double bottom border	Alt + H + B + U		Borders and Outlines
Draw Border	Alt + H + B + W		Borders and Outlines
Draw Border Grid	Alt + H + B + G		Borders and Outlines
Erase Border	Alt + H + B + E		Borders and Outlines
Show/Hide Gridlines	Alt + P + VG	Yes	Borders and Outlines
Open Format Cell Window	Ctrl + 1		Cell Formatting
Open Format Cell Window	Alt + H + FN		Cell Formatting
Close Format Cell Window	Esc		Cell Formatting
Format cell alignment	Alt + H + FQ + M		Cell Formatting
Change Cell Format	Alt + H + N		Cell Formatting
Accounting Number Format	Alt + H + AN		Cell Formatting
Format cell as percent	Alt + H + P		Cell Formatting
Format numbers with a thousand seperator	Alt + H + K		Cell Formatting
Format Painter	Alt + H + FP		Cell Formatting
Make a number into General Format	Ctrl + Shift + ~		Cell Formatting
Change cell value into time format	Ctrl + Shift + @		Cell Formatting
Change cell value into date format	Ctrl + Shift + #		Cell Formatting
Change cell value into currency format	Ctrl + Shift + $		Cell Formatting
Change cell value into percent format	Ctrl + Shift + %		Cell Formatting
Enter current time in selected cell	Crtrl + Shift + ;		Cell Level
Enter current time in selected cell	Crtrl  + ;		Cell Level
Change Background Color	Alt + H + H		Cell Level
Go to a specific cell	Ctrl + G		Cell Level
Switch between showing Excel formulas or their values in cells	Ctrl + ~		Cell Level
Move to Cell A1	Ctrl + Home		Cell Level
Delete Cell Contents	Delete Key		Cell Level
Merge Cells	Alt + H + M + M		Cell Level
Unmerge Cells	Alt + H + M + U		Cell Level
Copy Value from other cell	Alt + "		Cell Level
Make a number into comma fomat	Ctrl + Shift + !		Cell Level
Copy Formula from above cell	Ctrl + '		Cell Level
Move one Cell down	Enter		Cell Level
Move one cell up	Shift + Enter		Cell Level
Move one Cell right	Tab		Cell Level
Move one cell left	Shift + Tab		Cell Level
Select current region around active cell	Ctrl + Shift + *		Cell Level
Fill value of left cell in current cell	Ctrl + R		Cell Level
Change Cell Styles	Alt + H + J		Cell Level
Insert Cell	Alt + H + I + I		Cell Level
Delete cell	Alt + H + D + D		Cell Level
Display the formula in each cell instead of value	Alt + M + H	Yes	Cell Level
Extend selection by one cell right	Shift + Right Arrow		Cell Selection
Extend selection by one cell left	Shift + Left Arrow		Cell Selection
Extend selection by one cell Up	Shift + Up Arrow		Cell Selection
Extend selection by one cell Down	Shift + Down Arrow		Cell Selection
Extend selection to the last cell right	Ctrl + Shift + Right Arrow		Cell Selection
Extend selection to the last cell left	Ctrl + Shift + Left Arrow		Cell Selection
Extend selection to the last cell Up	Ctrl + Shift + Up Arrow		Cell Selection
Extend selection to the last cell Down	Ctrl + Shift + Down Arrow		Cell Selection
Extend selection up one screen	Shift + PgUp		Cell Selection
Extend selection down one screen	Shift + PgDn		Cell Selection
Extend selection left one screen	Alt + Shift + PgUp		Cell Selection
Extend selection right one screen	Alt + Shift + PgDn		Cell Selection
Extend selection to start of the row	Shift + Home		Cell Selection
Extend selection to first cell in the worksheet	Ctrl + Shift + Home		Cell Selection
Extend selection to last cell in the worksheet	Ctrl + Shift + End		Cell Selection
Select entire Column	Ctrl + Space		Column Level
Hide the selected columns	Ctrl + 0 (Zero)		Column Level
Insert Column(s)	Alt + H + I + C		Column Level
Delete column(s)	Alt + H + D + C		Column Level
Set column width	Alt + H + O + W		Column Level
Autofit Column Width	Alt + H + O + I		Column Level
Set standard column width	Alt + H + O + D		Column Level
Freeze first column	Alt + W + F + C		Column Level
New Comment	Alt + R + C		Comments
Delete Comment	Alt + R + D		Comments
Goto Previous Comment	Alt + R + V		Comments
Goto Next Comment	Alt + R + N		Comments
Show/Hide Comment	Alt + R + H	Yes	Comments
Show All Comment	Alt + R + A	Yes	Comments
Edit Cell Comment	Shift + F2		Comments
Select cells with comments	Ctrl + Shift + O		Comments
Conditional Formatting	Alt + H + L		Conditional Formatting
Conditional Formatting- Highlight Cells Rule- Greater than	Alt + H + L + H + G		Conditional Formatting
Conditional Formatting- Highlight Cells Rule- Less than	Alt + H + L + H + L		Conditional Formatting
Conditional Formatting- Highlight Cells Rule- Between	Alt + H + L + H + B		Conditional Formatting
Conditional Formatting- Highlight Cells Rule- Equal To	Alt + H + L + H + E		Conditional Formatting
Conditional Formatting- Highlight Cells Rule- Text that contains	Alt + H + L + H + T		Conditional Formatting
Conditional Formatting- Highlight Cells Rule- A date occuring	Alt + H + L + H + A		Conditional Formatting
Conditional Formatting- Highlight Cells Rule- Duplicate Values	Alt + H + L + H + D		Conditional Formatting
Conditional Formatting- Highlight Cells Rule- More Rules	Alt + H + L + H + M		Conditional Formatting
Apply/Remove auto Filter	Alt + A + T	Yes	Filters
Apply/Remove auto Filter	Ctrl + Shift + L	Yes	Filters
Clear Filter	Alt + A + C		Filters
Advanced Filter	Alt + A + Q		Filters
Open Excel Help	F1		Function Keys
Edit the selected cell	F2		Function Keys
After a name has been created, paste names.	F3		Function Keys
Repeat last action	F4		Function Keys
Go to a specific cell	F5		Function Keys
Next Pane	F6		Function Keys
Spell check selected text or document	F7		Function Keys
Extend Mode	F8		Function Keys
Recalculate all Workbooks	F9		Function Keys
Activate Menubar	F10		Function Keys
Create chart from selected data in new worksheet	F11		Function Keys
Save As	F12		Function Keys
File Menu	Alt + F		Main Menu
Home Menu	Alt + H		Main Menu
Insert Menu	Alt + N		Main Menu
Page Layout Menu	Alt + P		Main Menu
Formulas Menu	Alt + M		Main Menu
Data Menu	Alt + A		Main Menu
Review Menu	Alt + R		Main Menu
View Menu	Alt + W		Main Menu
Open Context Menu	Shift + F10		Others
Delete the selected column or row	Ctrl + - (Minus)		Others
Text to columns	Alt + A + E		Others
Remove Duplicates	Alt + A + M		Others
Spell check selected text or document	Alt + R + S		Others
Visual Basic Editor	Alt + F11		Others
Insert Hyperlink	Ctrl + K		Others
Expand/Collapse the ribbon (toolbars)	Ctrl + F1	Yes	Others
Display Paste special dialog box	Ctrl + Alt + V		Others
Create embedded chart	Alt + F1		Others
Insert Table	Ctrl + T		Others
Move to right edge of data region	Ctlr + Right arrow		Others
Move to left edge of data region	Ctlr + Left arrow		Others
Move to top edge of data region	Ctlr + Top arrow		Others
Move to bottom edge of data region	Ctlr + Bottom arrow		Others
Display autocomplete list	Alt + Down Arrow		Others
Create Table	Ctrl + L		Others
Freeze/Unfreeze Panes	Alt + W + F + F		Others
Split- Divide window in separate panes	Alt + W + S		Others
View Recently used functions	Alt + M + R		Others
View Normal Page	Alt + W + L		Page Layout
View Page Break Preview	Alt + W + I		Page Layout
Page Layout view	Alt + W + P		Page Layout
Custom Views	Alt + W + C		Page Layout
Set margin size of the document	Alt + P + M		Page Layout
Open custom margins window	Alt + P + M + A		Page Layout
Change Page Orientation	Alt + P + O		Page Layout
Choose paper Size	Alt + P + SZ		Page Layout
Open File Print Preview	Ctrl + F2		Printing
Bring up the print dialog box to begin the printing process	Ctrl + P		Printing
Print/Don’t print Gridlines	Alt + P + PG	Yes	Printing
Print/Don’t print Headings	Alt + P + PH		Printing
Select entire row	Shift + Space		Row Level
Hide the selected row	Ctrl + 9		Row Level
Move to beginning of row	Home		Row Level
Insert row(s)	Alt + H + I + R		Row Level
Delete row(s)	Alt + H + D + R		Row Level
Set row height	Alt + H + O + H		Row Level
Autofit row height	Alt + H + O + A		Row Level
Freeze top row	Alt + W + F + R		Row Level
Show/Hide Formula Bar	Alt + W + VF		Show/Hide
Show/Hide Headings	Alt + W + VH		Show/Hide
Show/Hide Ruler	Alt + W + R		Show/Hide
Show/Hide Headings	Alt + P + VH	Yes	Show/Hide
Multiple lines of text in one cell	Alt + Enter		Text Formatting
Change Font	Alt + H + FF		Text Formatting
Change Font Size	Alt + H + FS		Text Formatting
Increase Font Size by 1 point	Alt + H + FG		Text Formatting
Decrease Font Size by 1 point	Alt + H + FK		Text Formatting
Make Text Bold	Ctrl + B	Yes	Text Formatting
Make Text Italics	Ctrl + I	Yes	Text Formatting
Make Text Underline	Ctrl + U	Yes	Text Formatting
Change Text Colour	Alt + H + FC		Text Formatting
Double Underline	Alt + H + 3 + D	Yes	Text Formatting
Strikethrough selected text/cell(s)	Ctrl + 5	Yes	Text Formatting
Top Align Text	Alt + H + AT		Text Formatting
Middle Align Text	Alt + H + AM		Text Formatting
Bottom Align Text	Alt + H + AB		Text Formatting
Left Align Text	Alt + H + AL		Text Formatting
Center Align Text	Alt + H + AC		Text Formatting
Right Align Text	Alt + H + AR		Text Formatting
Make Text angle counterclock wise	Alt + H + FQ + O	Yes	Text Formatting
Make Text angle clock wise	Alt + H + FQ + L	Yes	Text Formatting
Make Text vertical	Alt + H + FQ + V	Yes	Text Formatting
Rotate text up	Alt + H + FQ + U	Yes	Text Formatting
Rotate text down	Alt + H + FQ + D	Yes	Text Formatting
Wrap Text	Alt + H + W	Yes	Text Formatting
Cut	Ctrl + X		Text Operations
Copy	Crtrl + C		Text Operations
Paste	Ctrl + V		Text Operations
Copy as picture	Alt + H + C + P		Text Operations
Find	Ctrl + F		Text Operations
Replace	Ctrl + H		Text Operations
Undo	Ctrl + Z		Text Operations
Redo	Ctrl + Y		Text Operations
Select all text from the cursor position to the end	Ctrl+Shift+End		Text Operations
View Clipboard	Alt + H + FO	Yes	Text Operations
Decrease Indent	Alt + H + 5		Text Operations
Increase Indent	Alt + H + 6		Text Operations
Merge and Center	Alt + H + M + C	Yes	Text Operations
Merge Across	Alt + H + M + A		Text Operations
Increase decimal places	Alt + H + 0		Text Operations
Decrease decimal places	Alt + H + 9		Text Operations
Sort in Ascending order	Alt + A + SA		Text Operations
Sort in Descending order	Alt + A + SD		Text Operations
Open sort window for sorting on multiple columns	Alt + A + SS		Text Operations
Find previous match	Ctrl + Shift + F4		Text Operations
Find next match	Shift + F4		Text Operations
Select all precedents	Ctrl + Shift + {		Trace Formulas
Select all dependents	Ctrl + Shift + }		Trace Formulas
Select direct precedents	Ctrl + [		Trace Formulas
Select direct dependents	Ctrl + ]		Trace Formulas
Trace Precedents - Shows cells affecting value of selected cell	Alt + M + P		Trace Formulas
Trace Dependents - Shows cells affected by value of selected cell	Alt + M + D		Trace Formulas
Remove all arrows showing drawn by trace options above	Alt + M + A + A		Trace Formulas
Remove all arrows showing drawn by trace precedents	Alt + M + A + P		Trace Formulas
Remove all arrows showing drawn by trace dependents	Alt + M + A + D		Trace Formulas
New Window- Open a different window for your document so that you can work at different places at same time	Alt + W + N		Workbook Level
Arrange all open windows as you want	Alt + W + A		Workbook Level
Move window(When window is not maximized)	Ctrl + F7		Workbook Level
Resize window(When window is not maximized)	Ctrl + F8		Workbook Level
Hide Window	Alt + W + H		Workbook Level
Unhide Window	Alt + W + U		Workbook Level
Minimize current window	Ctrl + F9		Workbook Operations
Maximize selected window	Ctrl + F10		Workbook Operations
Switch between open workbooks or windows	Ctrl + F6		Workbook Operations
Close Workbook and exit	Alt + F4		Workbook Operations
Protect Workbook	Alt + R + PW		Workbook Operations
Share Workbook	Alt + R + W		Workbook Operations
Protect and Share Workbook	Alt + R + O		Workbook Operations
New Workbook	Ctrl + N		Workbook Operations
Zoom your document to the level you want	Alt + W + Q		Worksheet Level
Zoom your document to 100%	Alt + W + J		Worksheet Level
Open a File	Ctrl + F12		Worksheet Operations
Save As	Alt + F2		Worksheet Operations
Insert New Worksheet	Alt + Shift + F1		Worksheet Operations
Save	Ctrl + S		Worksheet Operations
Move between work sheets in the same document	Ctrl + PageUp		Worksheet Operations
Move between work sheets in the same document	Ctrl + PageDown		Worksheet Operations
Close a spreadsheet	Ctrl + W		Worksheet Operations
Open a spreadsheet	Ctrl + O		Worksheet Operations
Select the entire worksheet	Ctrl + A		Worksheet Operations
Select the entire worksheet	Ctrl + Shif t + Spacebar		Worksheet Operations
Protect Sheet	Alt + R + PS		Worksheet Operations
Move to last cell in the worksheet	Ctrl + End		Worksheet Operations
Insert new sheet	Alt + H + I + S		Worksheet Operations
Delete Sheet	Alt + H + D + S		Worksheet Operations
Change Theme of the sheet	Alt + P + TH		Worksheet Operations