Based on surveys, we have compiled a list of the most popular Excel shortcuts you will find. The list is a little bit long, but if you know the shortcuts when you are working with Excel, you are good to go.
Results from Surveys
Around 99% of the people who took the survey said that Excel shortcuts are very important and helpful. There are more than two hundred Excel shortcuts, but 26% of the people that took the survey knew about 10 or less of these shortcuts, 61% knew about 50 shortcuts, while 10% knew about 100 shortcuts only.
Why You Should Learn the Shortcuts
Learning the shortcuts is important due to the following reasons:
Excel makes working faster and with more efficiency an easier task
You can manage large amounts of information
You can cope with tedious work without having to worry a lot
You can easily maintain consistency and accuracy in all your tasks
You can easily understand how to work with Excel
Excel Has Been In Use for Many Years
20% of the people who took the survey have been using Excel for approximately five years.
73% of the people who took the survey have been using Excel for more than a period of five years.
52% of the people who took the survey have been using Excel for more than a period of ten years.
Excel’s Most Popular Shortcuts
Extend Selection: These are the control shift arrow keys. They are very important shortcuts when you are working with a pile of data and would like to move your selection to the edge or the bottom.
Cut, Copy, and Paste: You can use these shortcuts by using the Ctrl key with X, C, or V. This is a very common shortcut because other applications utilize the same shortcut as well.
Fill Down: You can easily copy values from other cells without having to use copy paste and simply use Ctrl D. You can even use Ctrl + R.
Paste Special: This is a powerful shortcut because it allows you to paste formulas, values, and formats, and even paste the column widths by using Ctrl + Alt + V.
Autosum: This shortcut will automatically add up rows and columns of data with just one step.
Toggle Formula References: No one likes to go through the hassle of having to add $ signs in every single formula. You can simply use the F4 key to rotate through all the formula reference options and get the desired results such as (B1, $B$1, $B1, B$1).
Toggle Filters: This shortcut is very useful if you want to clear and apply all filters. All you have to do is use the Ctrl + Shift + L keys.
Ctrl + A: Select all text in the same area by using this key and you can use it whenever you would like to select all the data present in a table.
Date and Time: If you need to add the date or the time, then you can use Ctrl +; (date) Ctrl + Shift + (time).
Repeat Previous Action: The last action that you conducted can be repeated by using the Ctrl + Y keys or F4 key.
Go to First or Last Cell: You can now move from the fifth or any cell to the beginning or to the end within a matter of seconds. All you have to do is press Ctrl + Home, Ctrl + End.
Fill Handle: You can copy a formula by double clicking the tiny square at the bottom right of every selection.
Data Navigation: You can now easily move through data without having to worry about scrolling by simply using the Ctrl + arrow keys. They will move you to the edges of the sets of information easily.
Edit Cell: You can now edit cells with the F2 key without having to take your hands off of the keyboard.
Enter More than One Cell: Use the Ctrl + Enter keys to add more cells whenever you want.
Format Cells: You can use Ctrl + 1 to format nearly anything you would like to fix in Excel.
Delete and Insert Rows and Columns: You can now easily insert new columns and rows by simply using the Ctrl + Shift ++ keys and even delete them by using Ctrl +-.
New Table: Tables are very convenient when it comes to handling large amounts of data. You can simply add in a new table by using Ctrl + T.
Toggles Formulas Off and On: You can easily take a look at all the formulas present in Excel by using Ctrl +, and turn the formulas off and on whenever you want to.