Learn These Shortcuts To Sharpen Your Excel Skills

0

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

Worksheets and Workbooks

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

Row and Column Selection

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

Key selection for Pivot Table

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

Formulas and Functions

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

Formatting Shortcut keys

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+!

General Excel Shortcuts

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.