WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Top 20 Keyboard Shortcuts in Excel

Top 20 Keyboard Shortcuts in Excel

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

TOP 20 Keyboard Shortcuts in Excel

Almost everyone uses MS Excel in some or other ways to carry out their work in the workplace. If you do not know the speed of your work, it dents your productivity. Therefore today, we will discuss the most important keyboard shortcuts in excel you need to increase your productivity.

There is an N number of formulas and keyboard shortcuts in excel. You do not need to know each one of them. Just look into the daily requirement in your career and learn one by one at each level.

I know “Ctrl + C, Ctrl + V, Ctrl + X” are the very basic universal keyboard shortcuts in excel you use day in day out. If you really want to see yourself at an expert level, you need to go beyond all these.

Excel has much more than you have ever imagined. Today I will brief you about the most needed shortcuts in excel for every individual who works on excel every day.

Top 20 Excel Shortcuts

#1 – Excel Paste as Values Shortcut

We often copy many things in excel, but sometimes we do copy formula cells or ranges to another place. When you are copying and pasting formula cells, if you do a normal paste, you will end up pasting only formulas, not values. That is where the power of “Paste Special” plays a big role.

TOP 20 excel shortcuts - Paste as Values

TOP 20 excel shortcuts - Paste as Values 1

If you look at the cell C2, it is a dependent cell on B2 and A2. So now, copy and press “ALT+E+S+V.” It will open the below dialogue box and click ok.

TOP 20 excel shortcuts - Paste as Values 2

It will paste as values

TOP 20 excel shortcuts - Paste as Values 3

#2 – Auto Sum Shortcuts in Excel

In excel, we often do a summation of many things. Everywhere we cannot apply the SUM in excel function manually; instead, we have as an excel keyboard shortcuts key to doing the same for you.

TOP 20 excel shortcuts - Auto Sum

TOP 20 excel shortcuts - Auto Sum 1

#3 – Fill Down Keyboard Excel Shortcut

Fill down in excel is the action you need to do when there is data entry in excel. In many cases, we may need to copy and paste the value as it is in the above cell.

Note: If the value is there in the above cell, it will fill only values. If there is a formula, it will fill the formula to the below cell.

TOP 20 excel shortcuts - Auto Sum 2

TOP 20 excel shortcuts - Auto Sum 3

#4 – Select Entire Row and Column

In excel, we often need to select either the entire row or the entire column. Excel shortcuts would be handy in these situations.

TOP 20 excel shortcuts - Select Entire Row and Column

excel short cut - shift + Space

TOP 20 excel shortcuts - Select Entire Row and Column 2

excel short cut - cntrl + Space fpr column

#5 – Delete & Add Entire Row or Column

The way how we need to insert new rows or columns, there is also a need we need to delete rows in excel and columns. Keyboard shortcuts in excel will help you in increasing productivity.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

TOP 20 excel shortcuts - Delete & Add Entire Row or Column

excel short cut - Ctrl +

TOP 20 excel shortcuts - Delete & Add Entire Row or Column 1

excel short cut - Ctrl -

#6 – Insert Comment and Edit Comment Excel Shortcut

In a particular cell, we may need to put in our comments so that later we can remember what happened with that particular cell. Inserting comments manually is a boring task which nobody likes doing. Below are the Excel keyboard shortcuts to insert and edit the comment.

TOP 20 excel shortcuts - Insert Comment and Edit Comment

excel short cut - Right Click + M

TOP 20 excel shortcuts - Insert Comment and Edit Comment 1

excel short cut - Shift + F2

#7 – Move between Sheets

When you are working in excel, we deal with many sheets in a workbook. Often we need to switch between these sheets to finish our job. Manually going to sheets is a tedious task. There are excel keyboard shortcuts to increase our productivity level.

TOP 20 excel shortcuts - Moves between Sheets

excel short cut - Ctrl + PgDn

TOP 20 excel shortcuts - Moves between Sheets 1

excel short cut - Ctrl + PgUp

In order to go from Sheet1 to Sheet2 or Sheet3, press Ctrl + Page Down.

Right now, we are in Sheet2. To go to Sheet1, press Ctrl+Page Up.

To go to Sheet3, press Ctrl+PageDown.

#8 – Apply Filter

You can apply and remove the filter from the home tab ribbon in excel, but still, it takes a minimum of 5 seconds to do this. However, there are excel keyboard shortcuts that do this in just 1 second.

Apply Filter

shift + Ctrl L

Apply Filter 1

#9 – Freeze Row & Column Shortcuts in Excel

When you are working in many rows and columns, there is a need to freeze your first row and first column. Here is the Excel Keyboard Shortcuts to freeze your top row and column.

Freeze Row & Column

Note: It is important to select the cell, which is below the heading, then press ALT+W+F+F.

Alt + W + F + F

#10 – Open Formatting Dialogue Box

Formatting is the technique we tend to use to format any cell or range of cells in excel. In general, in the case of a scenario, we right-click on the cell or range of cells and select the format option.

Open Formatting Dialogue Box

Ctrl + 1

#11 – Adjust Your Column Width

In order to adjust the column width, it requires you to double click on the column edge. There are keyboard excel shortcuts to do this

Adjust Your Column Width

Alt + O + C + A

#12 – Repeat the Last task

In excel, we need to repeat the last task we did. It could be formatting, insert a new row or column, deleting the row or column, etc… In these cases, excel shortcuts F4 is handy.

Repeat the Last Task F4

#13 – Insert line breaker inside the cell

When you are writing in a cell, there is a need to insert a new line breaker inside the cell. Nobody would have told you about this. You must have tried many things, but one simple excel keyboard shortcuts can do wonders for you.

Insert line breaker inside the cell

Alt + Enter

#14 – Moves Between Different Workbooks

We all often work with different workbooks in our workplace. The most popular excel shortcuts ALT+TAB will go through all the software that is opened on your PC or laptop.

However, you can go through all the opened excel workbooks in just a click, i.e., CTRL + TAB.

Alt + Tab

#15 – Spell Check Excel Shortcut

We all work with data in Microsoft Applications. While typing, we often make spelling mistakes, but we do not know where we went wrong. Excel shortcuts F7 will loop through all the cells in the active sheet and do the spell check.

Spell Check F7

F7

#16 – Moves Between Excel Sheet and Excel VBA Editor

When you are working with macros, we tend to move between VBA editor and worksheet. To make the process the less stressful, excel keyboard shortcuts is ALT + F11.

 F11

#17 – Select the Set of Range: Shift + Ctrl + Arrow Keys 

When we want to select the set of ranges, we struggle a big-time selecting it manually. However, excel shortcuts can make life easier and allows us to breathe.

select the set of range

For Example, if we need to select the data from A1 to E100, we can use SHIFT + CTRL + Arrow Keys.

Select the cell A1 hold SHIFT + CTRL + Right Arrow + Down Arrow.

excel shortcut - Shift + Cntrl + Right Arrow + Down Arrow

#18 – To go to the last cell of the Row or Column

Assume you want to the last cell in the column from the cell A1. You cannot scroll down until the last cell. Ctrl + Down Arrow can do the job for you.

TOP 20 excel shortcuts - To go to last cell of the Row or Column

shortcut - Ctrl + Down Arrow

To go to last cell of the Column 1

#19 – Delete the Active Sheet Excel Shortcut

When we want to delete the sheet, we often do this manually. With just a click of the keyboard, we can be able to do that.

Delete the Active Sheet

#20 – To Insert New Sheet

Often we are required to add new sheets to our workbook. In just a click, we can do that.

shift F11 Insert new sheet

Note: Only F11 will insert a new chart.

F11 - Insert a chart

Recommended Articles

This has been a guide to Top 20 Keyboard Shortcuts in Excel. Here we discuss the working of keyboard shortcuts and how to use these excel shortcuts to save your time. You may learn more about Excel from the following articles –

  • Excel Insert Shortcuts
  • Using Excel Shortcuts to Select Row
  • Add Rows in Excel Shortcuts
  • Programming in Excel
120 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More