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.

Moving Around in a Worksheet or Cell
Shortcut keys for alignment in Excel
Merge shortcut key in MS Excel
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 |
Best Online Mock Tests for CSEET | CS Foundation | CA Foundation | CA Inter |IPCC | CA Final Exams | CS executive | CMA Foundation | GST | Income Tax |
Click the above links for online preparation.
eKVIJ provide subject wise and chapter wise MCQ’s.
hanuman chalisa telugu
అతులిత బలధామం స్వర్ణశైలాభ దేహం
దనుజవన కృశానుం జ్ఞానినా మగ్రగణ్యం
సకల గుణ నిధానం వానరాణా మధీశం
రఘుపతి ప్రియభక్తం వాతజాతం నమామి
Click here for hanuman chalisa telugu audio
Practicing chartered accountant by Top City
Chartered accountant in Mumbai
Chartered accountant in Bangalore
Chartered accountant in Hyderabad
Chartered accountant in Ahmedabad
Chartered accountant in Chennai
Chartered accountant in Kolkata
Chartered accountant in Jaipur
Chartered accountant in Visakhapatnam
Chartered accountant in Kanpur
Chartered accountant in Nagpur
Chartered accountant in Lucknow
Chartered accountant in Bhopal
Chartered accountant in Indore
Chartered accountant in Pimpri-chinchwad
Chartered accountant in Vadodara
Chartered accountant in Ghaziabad