Excel Shortcut: If you are Beginner on Excel and you do everything by mouse. So this is a blog only for you. There is so much demand in the market for people who knows and uses excel shortcuts while working on Microsoft excel. There is research that says if a person uses shortcuts of excel He can save 30 minutes per day . and it would be 120 hours per year. A report says a user learns only 20 most Used excel shortcuts his work flow will be better. You need to learn also google sheet Shortcut too. becuase some companies demands google sheets formulas. to understands difference between Google Sheet vs Excel you can read our other blog which we have cleary showed difference.
Excel Shortcut for save / Excel Shortcut Cheet Sheet
Action | Shortcut | Description |
Copy | Ctrl + C | Copies selected cell(s) |
Pest | Ctrl + V | Pastes copied cell(s) |
Cut | Ctrl + X | Cuts selected cell(s) |
Undo | Ctrl + Z | Undoes last action. |
Redo | Ctrl + Y | Redoes last undone action. |
Open Workbook | Ctrl + O | Opens an existing workbook. |
New Workbook | Ctrl + N | Creates a new workbook. |
Find | Ctrl + F | Opens Find dialog. |
Replace | Ctrl + R | Opens Replace dialog. |
Select Entire Row | Shift + Space | Selects the entire row. |
Select Entire Column | Ctrl + Space | Selects the entire column. |
AutoSum | Alt + = | Automatically sums up a range of cells. |
Filter | Ctrl + Shift + L | Apply Filter On data |
Insert Current Date | Ctrl + ; | Inserts today’s date in a cell. |
Insert Current Time | Ctrl + Shift + ; | Inserts current time in a cell. |
Go to Cell A1 | Ctrl + Home | Navigates to cell A1 from anywhere in the sheet. |
Cell Editing | F2 | To Edit the Cell |
Add Row, Column | Ctrl + | Insert Row, Column anywhere. (if using on google sheet use shift key with ctrl). |
Remove Row, Column | Ctrl – | Remove Row, Column anywhere. (if using on google sheet use shift key with ctrl). |
Excel shortcuts why you should use
A research says if a pro user of Microsoft excel can be 30% more productive rather than normal excel users. if you want to enhance your excel work speed. so you just need to use these shortcuts and Excel formulas into your work. and after using you will see clearly difference between last work and after using these. Excel has over 500+ Shortcuts. So comment us How many do you know ? and if you don’t know about excel shortcuts and want to learn a well structered course of excel and google sheet you can fill inquiry form and our team will connect to you.