Basic Shortcuts in Excel
These are the Shortcuts that are used to perform some basic tasks such as opening help, undoing, redoing the last action, and many more.
Shortcuts |
Descriptions |
---|---|
F1 |
To open Help |
Ctrl + Z |
To Undo the last action |
Ctrl + Y |
To redo the last action |
Ctrl + C |
To copy the Selected data |
F4 |
To Repeat the last action |
Ctrl +X |
To cut the selected data |
Ctrl + V |
To paste the Content from the clipboard |
Ctrl + Alt + V |
To display the paste special dialog box |
Ctrl+ F |
To display the find and replace with the find tab selected |
Ctrl + H |
To display the find and replace with the Replace tab selected |
Ctrl+ Shift + F4 |
Find the previous match |
Shift +F4 |
Find the next match |
Alt + F1 |
Insert Embedded chart |
F11 |
Insert a chart in a new sheet |
Ctrl + Shift + L |
Toggle Autofilter |
Atl + (Arrow down button) |
Activate Filter |
Ctrl + T or Ctrl + L |
Create Table |
Shift + Space |
Select Table row |
Ctrl + Space |
Select Table column |
Ctrl + A |
Select the table when the active cell is in the table |
Clear Slicer Filter |
Atl + C |
Run Spellcheck |
F7 |
Open the Macro Dialog box |
Alt + F8 |
Open VBA Editor |
Alt + F11 |
Duplicate object, Formula, Text | Ctrl + D |
Snap to grid | Alt |
Hide or show objects | Ctrl + 6 |
Open modify cell style dialog box | Alt + ‘ |
Show right-click menu | Shift + F10 |
Display control menu | Alt Space |
Top 100+ Excel Shortcut Keys List (A to Z)
Did you know that using keyboard shortcuts can increase productivity and save you time? Although the term “shortcut” may seem intimidating, it’s important to consider the benefits if you use computers every day!
Here, we provide a list of all essential list of excel shortcut keys, Starting with Basic Excel Shortcuts to advanced Excel shortcut keys.
We have also compiled all the essential computer shortcut keys, which include shortcuts for popular software like Microsoft Word, Excel, PowerPoint, and Gmail, as well as special characters and shortcuts relevant to competitive exams.
Contact Us