What is Microsoft excel?
We have provided a list of 50 Microsoft excel shortcuts. But first, go through what is Microsoft excel. Microsoft Excel is a widely used spreadsheet software that is used for data analysis, financial modeling, and much more. It allows users to organize and manipulate large sets of data, create charts and graphs, and perform complex calculations.
Why it’s important to know Microsoft excel shortcuts?
Knowing Microsoft excel shortcuts is important because it can help you work more efficiently and save time. Instead of clicking through menus and submenus to access the desired command, you can use keyboard shortcuts to perform actions quickly and easily. This can make a big difference when working with large amounts of data or when working on time-sensitive projects.
| Shortcut | Description |
| Ctrl + N | Create a new workbook |
| Ctrl + O | Open an existing workbook |
| Ctrl + S | Save the current workbook |
| Ctrl + P | Print the current workbook |
| Ctrl + F | Find text in the current worksheet |
| Ctrl + H | Replace text in the current worksheet |
| Ctrl + Z | Undo the last action |
| Ctrl + Y | Redo the last action |
| Ctrl + X | Cut the selected cells |
| Ctrl + C | Copy the selected cells |
| Ctrl + V | Paste the copied or cut cells |
| Ctrl + A | Select all cells in the current worksheet |
| Ctrl + B | Apply or remove bold formatting |
| Ctrl + I | Apply or remove italic formatting |
| Ctrl + U | Apply or remove underline formatting |
| Ctrl + 1 | Open the Format Cells dialog box |
| Ctrl + 2 | Apply or remove the bold formatting |
| Ctrl + 3 | Apply or remove the italic formatting |
| Ctrl + 4 | Apply or remove the underline formatting |
| Ctrl + 5 | Apply or remove the strikethrough formatting |
| Ctrl + 6 | Show or hide objects in the current worksheet |
| Ctrl + 7 | Show or hide the standard toolbar |
| Ctrl + 8 | Show or hide the outline symbols |
| Ctrl + 9 | Hide the selected rows |
| Ctrl + 0 | Hide the selected columns |
| Ctrl + Shift + + | Insert cells |
| Ctrl + – | Delete cells |
| Ctrl + Shift + L | Apply or remove filter |
| Ctrl + Shift + C | Copy the selected cells with formatting |
| Ctrl + Shift + V | Paste copied cells with formatting |
| Ctrl + Shift + ~ | Apply the general number format |
| Ctrl + Shift + $ | Apply the currency number format |
| Ctrl + Shift + % | Apply the percentage number format |
| Ctrl + Shift + ^ | Apply the scientific number format |
| Ctrl + Shift + # | Apply the date format |
| Ctrl + Shift + @ | Apply the time format |
| Alt + = | AutoSum the selected cells |
| Alt + H + F + I | Insert a new worksheet |
| Alt + H + D + L | Delete the selected worksheet |
| Alt + H + H | Set the cell color |
| Alt + H + B | Set the cell border |
| Alt + H + F + F | Find and replace |
| Alt + H + S | Sort the selected cells |
| Alt + H + W | Wrap text |
| Alt + H + 0 | Hide the selected rows |
| Alt + H + 9 | Hide the selected columns |
| Alt + H + U + N | Unhide the selected rows |
| Alt + H + U + N + C | Unhide the selected columns |
| F2 | Edit the selected cell |
| F4 | Repeat the last action |
| F5 | Go to a specific cell |
| F7 | Spell check the current worksheet |
| F11 | Create a chart from the selected data |
| Ctrl + F1 | Show or hide the ribbon menu |
If you liked the above article, Do check out our other article on Microsoft shortcut keys and read more about other topics.