Excel, one of the most powerful Spread Sheet Program software that helps to Open, Create, Edit, Formatting, Calculate, Share and Print advanced datasheets. well, in this post, we learn about Microsoft Excel keyboard shortcuts List Pdf.
Not only, These all Microsoft Excel shortcut keys, save your time while your working time. but also, improve your computer skills.
A to Z MS Excel All Shortcut Keys
excel is quite complicated Spread Sheet Program software, there are multiple functions, formulas, and menus. that’s why we need some Excel All Shortcut Keys Which help to manage data and make our work easier. here is a complete list of the A to Z Excel All Shortcut Keys list.
Excel Shortcut Keys | Functions |
---|---|
Ctrl + A | To select all the cells on the page |
Ctrl + B | To bold any text or number |
Ctrl + C | To copy any text or number |
Ctrl + D | To fill a column in any text |
Ctrl+F | To use Find and Replace in a spreadsheet |
Ctrl+N | to create a new workbook |
Ctrl+S | to save a worksheet |
Ctrl+W | to close the worksheet |
Ctrl+Z | to take a step back |
Ctrl + Y | to repeat |
Ctrl + F | to search |
F12 | To open saved documents |
Ctrl + F4 | To close the worksheet |
F4 | Repeat the last command or action. |
Shift + F11 | to get a new worksheet |
Ctrl + F2 | To see a print preview of a worksheet |
F1 | To open the Help Box |
Alt + Q | To open Go To option |
F7 | to check to spell |
F9 | To count all worksheets in all open workbooks |
Shift + F9 | To count open worksheets |
Alt or F10 | To activate Menu Bar |
Ctrl + F1 | Show or hide the ribbon |
Ctrl + Shift + U | To expand or collapse the formula bar |
Ctrl + F9 | To minimize the worksheet |
F11 | To take a new chart |
Alt + F1 | To insert a chart sheet |
Alt + F | To open the File tab menu |
Alt + H | to go to the home tab |
Alt + N | To open the option of the Insert tab |
Alt + P | To go to the page layout tab |
Alt + M | To go to the Formulas tab |
Alt + A | To go to the Data tab |
Alt + R | To go to the Review tab |
Alt + W | To go to the View tab |
Alt + X | To go to the Add-ins tab |
Alt + Y | To go to the Help tab |
Ctrl+Tab | To switch between open worksheets |
Shift + F3 | function to insert |
Alt + F8 | To create a macro dialog box |
Alt + F11 | To open the Visual Basic Editor |
Moving shortcut keys for Excel
In the Excel spreadsheet, we can deal with cells and columns. with the help of MS Excel Moving shortcut keys to easily navigate your entire worksheets move cells in Excel using the keyboard, or which column to go to or automatically navigate your entire worksheet. let’s know about – Excel shortcut key for moving
Shortcut key | Functions |
---|---|
Left / Right Arrow | to move a cell left or right |
Ctrl+Left / Right Arrow | To go to the last and first cell of the row |
Up/Down Arrow | to move a cell up and down |
Ctrl+Up/Down Arrow | To move up or down a cell in a column |
Tab | to go to the next cell |
Shift+Tab | to go to the previous cell |
Ctrl+End | To go to the last cell of the worksheet |
F5 | To open the Go To option and go to any cell |
Home | Go to the leftmost cell in the current row |
Ctrl+Home | to go to the beginning of the worksheet |
Page Up/Down | To move up or down a screen in the worksheet |
Ctrl+Page Up/Down | To go to the previous and next worksheet |
Alt+Page Up/Down | To move one screen to the right or left in a worksheet |
Excel Selecting Cells Shortcut Keys
Are you using the mouse to select the cell and it consumes your time and it also slows your work? then don’t worry. let’s Explore the most important and useful Selecting Cells Shortcut Keys for excel. that save you time while you working in excel.
Shortcut Keys to Edit Cells in Excel | Functions |
---|---|
Shift+Left/Right Arrow | To select left and right of active cell |
Shift + Space | To select an entire row |
Ctrl+Space | To select an entire column |
Ctrl+Shift+Space | To select the entire worksheet |
F2 | To edit a cell |
Shift + F2 | To add a comment to an edit cell |
Ctrl + X | To cut a document |
Ctrl + Insert | To copy selected data, or selected cell range |
Shift + Insert | To paste selected data or select cell range |
Ctrl + Alt + V | To open the Paste Special dialog box |
Delete | To delete selected data or select cell range |
Alt + Enter | To start a new line in the same cell of a cell |
F3 | Paste the cell name |
Alt + H + D + C | to delete a column |
Esc | To cancel an entry in a cell or in the formula bar |
Enter | to command |
Excel Cell Formatting Shortcut Keys
Cell formatting is one of the best options to decorate or organize your data in a spreadsheet. to use the Cell Formatting Shortcut Keys you can easily create a text border, italic bold or underline the text, insert pie chart, Current date and time, and color the given data. so, let’s know Excel Formatting Shortcuts key pdf
Cell Formatting Shortcut | Functions |
---|---|
Ctrl + – | To delete documents |
Ctrl + ; | to enter today’s date |
Ctrl + : | To enter the time of Present |
Ctrl + 0 | To hide a column |
Ctrl + 1 | To format the cell dial log box |
Ctrl + 2 | To bold any document |
Ctrl + 3 | To italicize any document |
Ctrl + 4 | To underline in any document |
Ctrl + 5 | To cut off a document |
Ctrl + 6 | to make an object visible or hidden |
Ctrl + 7 | To show or hide the toolbar |
Ctrl + 8 | To see the outline symbol |
Ctrl + 9 | To hide (Row) |
Ctrl + A | To select all the cells in the range |
Ctrl + Alt + F9 | For Complete Calculation of All Worksheet |
Ctrl + Alt + Shift + F9 | to measure everything |
Ctrl + F10 | To Minimize or Restore |
Ctrl + F11 | 4.0 macro sheet insert |
Ctrl + F12 | To open any file |
Ctrl + F3 | To define the name |
Ctrl + F6 | To go to the Next Workbook window |
Ctrl + F7 | To move in the window |
Ctrl + F8 | To Resize Window |
Ctrl + G | Go to Option |
Ctrl + H | to replace |
Ctrl + I | To add or remove italics to some selected data or the contents of a selected cell range |
Ctrl + I | To italicize any document |
Ctrl + K | To add a hyperlink |
Ctrl + N | to fetch a new workbook |
Ctrl + O | To open files |
Ctrl + P | To print documents |
Ctrl + R | To fill the right part in Excel |
Ctrl + Shift + ! | Use for comma format |
Ctrl + Shift + ( | To Show any (Rows) |
Ctrl + Shift + ) | To show any column |
Ctrl + Shift + @ | To do time formatting |
Ctrl + Shift + * | To select the current region |
Ctrl + Shift + & | Any elected Outline border in Cell applying for |
Ctrl + Shift + # | To do date formatting |
Ctrl + Shift + % | percent format to the |
Ctrl + Shift + ^ | Ltd. Exponelation to Format It |
Ctrl + Shift + + | To insert Cell, Row, and Column |
Ctrl + Shift + $ | To format the currency |
Ctrl + Shift + 4 | To convert any cell into the currency |
Ctrl + Shift + 5 | To convert any cell to Percentage |
Ctrl + Shift + 6 | Mainly scientific marks Use to |
Ctrl + Shift + 7 | To create an outline around the selection |
Ctrl + Shift + A | In Formula insert name of arguments for |
Ctrl + Shift + F12 | To print any document |
Ctrl + Shift + F3 | To create a list by row and column name |
Ctrl + Shift + F6 | to go to the previous window |
Ctrl + Spacebar | To select the Present column |
Ctrl + U | to underline |
Ctrl W | To close the workbook |
Ctrl+Shift+_ (Underline) | To remove the outline border in any selected cell |
Shift + F10 | To show the shortcut menu |
Alt + ’ | To open the Format Style dialog box |
Alt + Down arrow | To show Auto-Complete List |
Alt + Esc | To go to the last two applications in the Taskbar |
Alt + F2 | Use any document to save as |
Alt + F4 | To exit any Workbook |
Alt + H + B | to add border |
Alt + i + c | To insert any column |
Alt + i + r | To insert any row |
Alt + Shift + F1 | To use for New Worksheet |
Alt + Shift + F2 | To save a workbook |
Alt or F10 | To activate any menu |
Conclusion
In this post, we collect all possible MS Excel All Shortcut Keys List Pdfs for our readers. these shortcut keys for excel are sure to help to save your working time and boost your working skills.
If you have read these keyboard shortcuts for excel pdf, then the information given in it will prove to be informative for you. Along with this, for your good practice, you can download all these shortcut keys by clicking on the Microsoft Excel Shortcut Keys pdf given below.