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 working, 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.
#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 do normal paste you will end up pasting only formulas not values. That is where the power of “Paste Special” plays a big role.
If you look 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.
It will paste as values
#2 – Auto Sum Shortcuts in Excel
In excel we often do a summation of many things. Everywhere we cannot apply the SUM function manually; instead, we have as an excel keyboard shortcuts key to doing the same for you.
#3 – Fill Down Keyboard Excel Shortcut
Fill down 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.
#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.
#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 and columns. Keyboard shortcuts in excel will help you in increasing productivity.
#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 comment manually is a boring task which nobody likes doing. Below is the Excel keyboard shortcuts to insert and edit the comment.
#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.
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 do this in just 1 second.
#9 – Freeze Row & Column Shortcuts in Excel
When you are working in many rows and columns there is need of freezing your first row and first column. Here is the Excel Keyboard Shortcuts to freeze your top row and column.
Note: It is important to select the cell, which is below the heading then press 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, case scenario we right click on the cell or range of cell and select the format option.
#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
#12 – Repeat the Last task
In excel we need to repeat the last task we did. It could be formatting, insert new row or column, deleting the row or column etc… In these cases, excel shortcuts F4 is handy.
#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.
#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 in your PC or laptop.
However, you can go through all the opened excel workbooks in just a click i.e. CTRL + 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.
#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.
#17 – Select the Set of Range: Shift + Ctrl + Arrow Keys
When we want to select the set of range, we struggle a big-time selecting it manually. However, excel shortcuts can make life easier and allows us to breathe.
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.
#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.
#19 – Delete the Active Sheet Excel Shortcut
When we want to delete the sheet, we often do this manually. Just a click of the keyboard we can be able to do that.
#20 – To Insert New Sheet
Often we required to add new sheets to our workbook. In just a click, we can do that.
Note: Only F11 will insert a new chart.
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 –