50 Microsoft excel shortcuts You Must Know

Microsoft excel shortcuts

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.

Ctrl + NCreate a new workbook
Ctrl + OOpen an existing workbook
Ctrl + SSave the current workbook
Ctrl + PPrint the current workbook
Ctrl + FFind text in the current worksheet
Ctrl + HReplace text in the current worksheet
Ctrl + ZUndo the last action
Ctrl + YRedo the last action
Ctrl + XCut the selected cells
Ctrl + CCopy the selected cells
Ctrl + VPaste the copied or cut cells
Ctrl + ASelect all cells in the current worksheet
Ctrl + BApply or remove bold formatting
Ctrl + IApply or remove italic formatting
Ctrl + UApply or remove underline formatting
Ctrl + 1Open the Format Cells dialog box
Ctrl + 2Apply or remove the bold formatting
Ctrl + 3Apply or remove the italic formatting
Ctrl + 4Apply or remove the underline formatting
Ctrl + 5Apply or remove the strikethrough formatting
Ctrl + 6Show or hide objects in the current worksheet
Ctrl + 7Show or hide the standard toolbar
Ctrl + 8Show or hide the outline symbols
Ctrl + 9Hide the selected rows
Ctrl + 0Hide the selected columns
Ctrl + Shift + +Insert cells
Ctrl + –Delete cells
Ctrl + Shift + LApply or remove filter
Ctrl + Shift + CCopy the selected cells with formatting
Ctrl + Shift + VPaste 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 + IInsert a new worksheet
Alt + H + D + LDelete the selected worksheet
Alt + H + HSet the cell color
Alt + H + BSet the cell border
Alt + H + F + FFind and replace
Alt + H + SSort the selected cells
Alt + H + WWrap text
Alt + H + 0Hide the selected rows
Alt + H + 9Hide the selected columns
Alt + H + U + NUnhide the selected rows
Alt + H + U + N + CUnhide the selected columns
F2Edit the selected cell
F4Repeat the last action
F5Go to a specific cell
F7Spell check the current worksheet
F11Create a chart from the selected data
Ctrl + F1Show 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.

Leave a Comment