If you want to become a pro while working on an Excel sheet, you need to learn all the shortcuts of excel to complete your task within a few minutes as we all know that Microsoft Excel is one of the essential tools of Microsoft OfficeSuite. Microsoft Excel makes your job simpler by allowing you to do your heavy calculations through the use of excel formulas. Excel enables you to make calculations on multiple workbooks and worksheets simultaneously so that you can finish your assigned task on time. Grasp these important shortcuts while working on Excel through this Microsoft Office Training Program and become proficient in it.
In this article, I will talk about some of the valuable and significant shortcuts you should memorize while working on the excel spreadsheet. These shortcuts will help you complete your assigned time task and focus on new projects daily. I want to tell you one thing that there are lots of shortcuts that you might not learn in one go. It will ultimately take a couple of days to learn all these shortcuts, which are essential while working on your Excel Sheet. I have one easy technique for you to grasp these shortcuts. Once your work shift ends, you can jot down the shortcuts on a piece of paper and learn them for the easy completion of your task. Before your work shifts start on the next day, go through these shortcuts once again and repeat these processes. It will help you to learn all the shortcuts quickly and to end your task at the desired time.
Here is the list of essential shortcuts which you must learn while operating on your Excel Sheet
TASK |
SHORTCUT KEYS |
Insert a new worksheet |
Shift+F11 |
Minimize current workbook |
Ctrl+F9 |
Maximize current workbook |
Ctrl+F10 |
Move to the next worksheet |
F6 |
TASK |
SHORTCUT KEYS |
Select entire row |
Shift+Space |
Select entire column |
Ctrl+Space |
Select entire range in the current selection |
Ctr+A |
Add adjacent cells to current selection |
Shift+Click |
Add non-adjacent cells to the current selection |
Ctrl+Click |
Cancel selection |
Esc |
TASK |
SHORTCUT KEYS |
Select entire pivot table |
Ctrl+A |
Group pivot table items |
Alt+Shift+right arrow |
Ungroup pivot table items |
Alt+Shift+left arrow |
Add pivot table to the current worksheet |
Alt+F1 |
Add pivot chart to the new worksheet |
F11 |
TASK |
SHORTCUT KEYS |
To put a relative and absolute reference |
F4 |
Calculate all worksheets |
F9 |
Autosum all selected cells |
Alt = |
Enter an array formula |
Ctrl+Shift+Enter |
Paste name into a formula |
F3 |
Choose autocomplete function |
TAB |
Open Insert Function Dialog Box |
Shift+F3 |
TASK |
SHORTCUT KEYS |
To do bold formatting of text/number |
Ctrl+B |
To do italic formatting of text/number |
Ctrl+I |
To do underline formatting of text/number |
Ctrl+U |
Aligning left the content of the cell |
Alt+H+A+L |
Aligning right the content of the cell |
Alt+H+A+R |
Aligning center the content of the cell |
Alt+H+A+C |
Indent |
Alt+H+6 |
Increase font by size |
Alt+H+F+G |
Decrease font by size |
Alt+H+F+K |
Percentage Formatting |
Ctrl+Shift+% |
Data Formatting |
Ctrl+Shift+# |
Ctrl+Shift+@ |
|
Numbers Formatting |
Ctrl+Shift+! |
TASK |
SHORTCUT KEYS |
Open a spreadsheet |
Ctrl+O |
Create new spreadsheet |
Ctrl+N |
Save a spreadsheet |
Ctrl+S |
Save as |
F12 |
Close Excel |
Alt+F4 |
I hope that the above article will help you learn Excel Shortcuts quickly and become proficient.