MS Excel Shortcut Keys

We all know that MS Excel Shortcut Keys are very useful to speed up our work. That’s why Microsoft office supports a wide range of MS Excel Shortcut Keys to complete our work more fast and comfort. Here we list out the most useful MS Excel Shortcut Keys supported by Microsoft Excel.

The more you use keyboard shortcuts, the easier they are to remember.

General Program Shortcuts

Moving Around in a Worksheet or Cell

Selecting Cells

Editing Cells

Formatting Cells

Shortcut keys for alignment in Excel

Merge shortcut key in MS Excel

Merge and center shortcut

Excel delete row shortcut

excel shortcut keys

General Program Shortcuts in excel shortcut keys

Excel Shortcut Keys	Description
Alt or F10	Key tips turn on or off
Alt+A	Go to the Data tab
Alt+F	Open the File tab menu
Alt+F1	Create an embedded bar chart based on select data (same sheet)
Alt+F11	Open the Microsoft Visual Basic For Applications Editor
Alt+F8	Create, run, edit, or delete a macro
Alt+H	Go to the Home tab
Alt+M	Go to the Formulas tab
Alt+N	Open the Insert tab
Alt+P	Go to the Page Layout tab
Alt+Q	Go to the “Tell me what you want to do” box
Alt+R	Go to the Review tab
Alt+W	Go to the View tab
Alt+X	Go to the Add-ins tab
Alt+Y	Go to the Help tab
Ctrl+F	Search in a spreadsheet or use Find and Replace
Ctrl+F1	Show or hide the ribbon
Ctrl+F2	Switch to Print Preview
Ctrl+F4	Close Excel
Ctrl+F9	Minimize the workbook window
Ctrl+N	Create a new workbook
Ctrl+O	Open an existing workbook
Ctrl+S	Save a workbook
Ctrl+Shift+U	Expand or collapse the formula bar
Ctrl+Tab	Switch between open workbooks
Ctrl+W	Close a workbook
Ctrl+Y	Redo an action
Ctrl+Z	Undo an action
F1	Open the Help pane
F11	Create a bar chart based on selected data (on a separate sheet)
F12	Open the Save As dialog box
F4	Repeat the last command or action. For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell.
F7	Check spelling
F9	Calculate all worksheets in all open workbooks
Shift+F11	Insert a new worksheet
Shift+F3	Insert a function
Shift+F9	Calculate active worksheets

Moving Around in a Worksheet or Cell

Excel Shortcut Keys	Description
Left/Right Arrow	Move one cell to the left or right
Ctrl+Left/Right Arrow	Move to the farthest cell left or right in the row
Up/Down Arrow	Move one cell up or down
Ctrl+Up/Down Arrow	Move to the top or bottom cell in the column
Tab	Go to the next cell
Shift+Tab	Go to the previous cell
Ctrl+End	Go to the most bottom right used cell
F5	Go to any cell by pressing F5 and typing the cell coordinate or cell name.
Home	Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell)
Ctrl+Home	Move to the beginning of a worksheet
Page Up/Down	Move one screen up or down in a worksheet
Alt+Page Up/Down	Move one screen to the right or left in a worksheet
Ctrl+Page Up/Down	Move to the previous or next worksheet

Selecting Cells

Excel Shortcut Keys	Description
Ctrl+A	Select the entire worksheet
Ctrl+Shift+Space	Select the entire worksheet
Ctrl+Space	Select the entire column
Shift+Left/Right Arrow	Extend the cell selection to the left or right
Shift+Space	Select the entire row

Editing Cell

Excel Shortcut Keys	Description
Alt+Enter	Insert a hard return within a cell (while editing a cell)
Alt+H+D+C	Delete column
Ctrl+Alt+V	Open the Paste Special dialog box
Ctrl+C or Ctrl+Insert	Copy contents of a cell, selected data, or selected cell range
Ctrl+V or Shift+Insert	Paste contents of a cell, selected data, or selected cell range
Ctrl+X	Cut contents of a cell, selected data, or selected cell range
Delete	Remove the contents of a cell, selected data, or selected cell range
Enter	Complete an entry in a cell or the formula bar
Esc	Cancel an entry in a cell or the formula bar
F2	Edit a cell
F3	Paste a cell name (if cells are named in the worksheet)
Shift+F2	Add or edit a cell comment

Formatting Cells

Ready to format some cells? These keyboard shortcuts make it easier!

Excel Shortcut Keys	Description
Alt+H+A+B	Bottom alignment to text
Alt+H+A+C	Center alignment to text
Alt+H+A+L	Left alignment to text
Alt+H+A+M	Middle alignment to text
Alt+H+A+R	Right alignment to text
Alt+H+A+T	Top alignment to text
Alt+H+B	Add a border
Alt+H+H	Select a fill color
Ctrl+0	Hide the selected columns
Ctrl+1	Open the Format Cells dialog box
Ctrl+5	Apply or remove strikethrough
Ctrl+9	Hide the selected rows
Ctrl+B	Add or remove bold to the contents of a cell, selected data, or selected cell range
Ctrl+I	Add or remove italics to the contents of a cell, selected data, or selected cell range
Ctrl+Shift+$	Apply currency format
Ctrl+Shift+%	Apply percent format
Ctrl+Shift+&	Apply outline border
Ctrl+Shift+_	Remove outline border
Ctrl+U	Add or remove underline to the contents of a cell, selected data, or selected cell range

Shortcut keys for alignment in Excel

For alignment there is no direct shortcut keys in MS Excel, By pressing “Alt + H” automatically key tips will turn on Home tab section, then we go through the tips.

Excel Shortcut Keys	Description
Alt+H+A+B	Bottom alignment to text
Alt+H+A+C	Center alignment to text
Alt+H+A+L	Left alignment to text
Alt+H+A+M	Middle alignment to text
Alt+H+A+R	Right alignment to text
Alt+H+A+T	Top alignment to text

Merge shortcut key in MS Excel

Sequential Merge and Center shortcut in excel (ALT + H then M+C) to merge and center two or more cells follow these steps: Select the cells. Press ALT key following by H then M and C keys on keyboard.

Excel Shortcut Keys	Description
Alt+H+M+C	To Merge and center two or more cells
Alt+H+M+A	To Merge two or more cells row wise
Alt+H+M+M	To Merge selected cells
Alt+H+M+U	To Unmerge the merged c ells

Excel delete row shortcut

For deleting cells in excel we use shortcut key as “Ctrl + – (minus)”, to deleting a entire row we do as follows

Shift + Spacebar to select the row.
Ctrl + – (minus sign) to delete the row.

Excel Shortcut Keys	Description
Shift + Spacebar then Ctrl + –	To delete entire row
Ctrl + Spacebar then Ctrl + –	To delete entire Column

MS Excel Shortcut keys using Single Key

Excel Shortcut keys	Description
Delete	Remove the contents of a cell, selected data, or selected cell range
Enter	Complete an entry in a cell or the formula bar
Esc	Cancel an entry in a cell or the formula bar
F1	Open the Help pane
F11	Create a bar chart based on selected data (on a separate sheet)
F12	Open the Save As dialog box
F2	Edit a cell
F3	Paste a cell name (if cells are named in the worksheet)
Alt / F10	Key tips turn on or off
F4	Repeat the last command or action. For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell.
F5	Go to any cell by pressing F5 and typing the cell coordinate or cell name.
F7	Check spelling
F9	Calculate all worksheets in all open workbooks
Home	Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell)
Left/Right Arrow	Move one cell to the left or right
Page Up/Down	Move one screen up or down in a worksheet
Tab	Go to the next cell
Up/Down Arrow	Move one cell up or down

MS Excel Shortcut keys using CTRL

Find out MS Excel Shortcut keys using CTRL

Excel Shortcut keys	Description
Ctrl+0	Hide the selected columns
Ctrl+1	Open the Format Cells dialog box
Ctrl+5	Apply or remove strikethrough
Ctrl+9	Hide the selected rows
Ctrl+A	Select the entire worksheet
Ctrl+Alt+V	Open the Paste Special dialog box
Ctrl+B	Add or remove bold to the contents of a cell, selected data, or selected cell range
Ctrl+C or Ctrl+Insert	Copy contents of a cell, selected data, or selected cell range
Ctrl+End	Go to the most bottom right used cell
Ctrl+F	Search in a spreadsheet or use Find and Replace
Ctrl+F1	Show or hide the ribbon
Ctrl+F2	Switch to Print Preview
Ctrl+F4	Close Excel
Ctrl+F9	Minimize the workbook window
Ctrl+Home	Move to the beginning of a worksheet
Ctrl+I	Add or remove italics to the contents of a cell, selected data, or selected cell range
Ctrl+Left/Right Arrow	Move to the farthest cell left or right in the row
Ctrl+N	Create a new workbook
Ctrl+O	Open an existing workbook
Ctrl+Page Up/Down	Move to the previous or next worksheet
Ctrl+S	Save a workbook
Ctrl+Shift+$	Apply currency format
Ctrl+Shift+%	Apply percent format
Ctrl+Shift+&	Apply outline border
Ctrl+Shift+_	Remove outline border
Ctrl+Shift+Space	Select the entire worksheet
Ctrl+Shift+U	Expand or collapse the formula bar
Ctrl+Space	Select the entire column
Ctrl+Tab	Switch between open workbooks
Ctrl+U	Add or remove underline to the contents of a cell, selected data, or selected cell range
Ctrl+Up/Down Arrow	Move to the top or bottom cell in the column
Ctrl+V or Shift+Insert	Paste contents of a cell, selected data, or selected cell range
Ctrl+W	Close a workbook
Ctrl+X	Cut contents of a cell, selected data, or selected cell range
Ctrl+Y	Redo an action
Ctrl+Z	Undo an action

MS Excel Shortcut keys using ALT

Find ou MS Excel Shortcut keys using ALT.

Shortcut Key	Description
Alt or F10	Key tips turn on or off
Alt+A	Go to the Data tab
Alt+Enter	Insert a hard return within a cell (while editing a cell)
Alt+F	Open the File tab menu
Alt+F1	Create an embedded bar chart based on select data (same sheet)
Alt+F11	Open the Microsoft Visual Basic For Applications Editor
Alt+F8	Create, run, edit, or delete a macro
Alt+H	Go to the Home tab
Alt+H+B	Add a border
Alt+H+D+C	Delete column
Alt+H+H	Select a fill color
Alt+M	Go to the Formulas tab
Alt+N	Open the Insert tab
Alt+P	Go to the Page Layout tab
Alt+Page Up/Down	Move one screen to the right or left in a worksheet
Alt+Q	Go to the “Tell me what you want to do” box
Alt+R	Go to the Review tab
Alt+W	Go to the View tab
Alt+X	Go to the Add-ins tab
Alt+Y	Go to the Help tab
Alt+H+A+B	Bottom alignment to text
Alt+H+A+C	Center alignment to text
Alt+H+A+L	Left alignment to text
Alt+H+A+M	Middle alignment to text
Alt+H+A+R	Right alignment to text
Alt+H+A+T	Top alignment to text
Alt+H+M+C	To Merge and center two or more cells
Alt+H+M+A	To Merge two or more cells row wise
Alt+H+M+M	To Merge selected cells
Alt+H+M+U	To Unmerge the merged c ells

MS Excel Shortcut Keys using Shift

Excel Shortcut Keys	Description
Shift+F11	Insert a new worksheet
Shift+F2	Add or edit a cell comment
Shift+F3	Insert a function
Shift+F9	Calculate active worksheets
Shift+Left/Right Arrow	Extend the cell selection to the left or right
Shift+Space	Select the entire row
Shift+Tab	Go to the previous cell