Skip to main content

The Eight Most Impactful Excel Shortcuts That You Should Master

fast-fingers-1529553-640x480
If you’ve ever gone online to research improving your Excel skills, you’ve undoubtedly come across a post or two listing all of Excel’s keyboard shortcuts.  In the latest version of Excel, Microsoft has made it easier than ever to learn shortcuts, by assigning shortcuts to nearly every function and making the discovery of the input sequence very transparent.
While memorizing Excel shortcuts will generally improve your productivity, not all shortcuts are created equal.  Shortcuts that you never use are not inherently not very useful and not worth memorizing.  Your focus should be on the shortcuts that have the most impact – either by the amount of time it saves you, the frequency that you’ll use them, or the behavior it encourages.
If you’ve already started using Excel or just haven’t utilized shortcuts heavily before, review the top eight shortcuts below.  For any that you don’t know already, I would suggest memorizing them and incorporating them into your Excel working style – I guarantee that doing so will provide an immediate boost to your productivity.

Sorting Tables

ALT → A → S → A    (Sort Ascending)
ALT → A → S → D    (Sort Descending)
Sort Shortcut
Knowing how to sort tables quickly is an extremely useful shortcut because of how often you’ll use it.  Sorting is generally the first task you’ll perform to orient yourself with data and easily see if there are duplicates within the field you just sorted.  Additionally, any time before you finalize a table to be presented to others, you’ll likely want it to have some type of sorting logic applied to at least one field.

AutoFilter

ALT → A → T
    or
CTRL + SHIFT + L
AutoFilter Shortcut
The AutoFilter shortcut is a powerful shortcut because, like sorting, you’ll use it frequently whenever you need to conduct data analysis.  With AutoFilter on, you can quickly limit your view of the data based on a set of filtering criteria.  Knowing this shortcut is also useful when you inherit a workbook and need to quickly remove AutoFilter, as leaving it on can easily cause errors.  Just type in the same shortcut sequence to remove the AutoFilter labels.

Inserting and Deleting Rows and Columns

ALT → I → R    (Insert Row)
ALT → I → C    (Insert Column)
ALT → H → D → R    (Delete Row)
ALT → H → D → C    (Delete Column)
Columns Rows Shortcut
As with any spreadsheet tool, Excel’s interface is intended to be extremely flexible, allowing you to place data, charts, tables, and even objects any way you like on the spreadsheet itself.  Because of this flexibility, one thing you’ll be doing often is inserting and deleting rows.  There have been countless times when I’d built a spreadsheet, realized that I needed either more or less space within the sheet, and manually performed the action by right clicking the mouse.  Had I been using these shortcuts all along, I would have saved myself a ton of time.

Inserting a PivotTable

ALT  D  P  F
    or
ALT  N  V  ENTER
PivotTable Shortcut
PivotTable is another great analysis tool that is sometimes underutilized either because people don’t know about the feature or they get confused by the steps required to insert a PivotTable.  Using this shortcut allows you to insert a PivotTable the quickest way possible.  By having this shortcut in hand, you’ll undoubtedly start using PivotTables more frequently and eventually become more proficient with the tool itself.  To prevent errors, just make sure that you are selecting a proper table (all headers filled with heading values, no random breaks of rows or columns) before you start the shortcut sequence.

Formatting Numbers

ALT → H → N → A → ENTER    (Accounting format)
ALT → H → K    (Comma separated format)
CTRL + SHIFT + 4    (Currency format)
CTRL + SHIFT + 5    (Percentage format)
CTRL + SHIFT + 1    (Two Decimal Place format)
Number Formatting Shortcut
If making your Excel files visually appealing is even slightly important to you, then changing theformat of number in Excel is something you’ll do constantly.  Using shortcuts is a way to make this process much more efficient.  There are a couple of other number formatting shortcuts available in Excel, but I’ve listed the ones you’ll likely use most frequently.
Note in the examples shown above that the first three formats add a small indent to the right side of the cell while the last two do not.  This is one difference between the comma separated and two decimal place format.

Inserting Comments

ALT → R → C
Comments Shortcut
I’ve stated before that not including documentation is one of the biggest mistakes people makeboth when creating and reviewing Excel files.  Always put yourself in the shoes of the person you may be handing off your file to and think about what information would be important to that person.  The comments shortcut allows you to add valuable context to your file without interfering with any of the data elements.  By knowing the shortcut combination, you’ll start to add comments more frequently and the workbooks you build will become more transparent.

Workbook Navigation

CTRL + PAGEDOWN    (Select next tab)
CTRL + PAGEUP    (Select previous tab)
Tab Navigation Shortcut
During my consulting career, there have been countless times when I’ve been I’ve been tasked with reviewing a client’s Excel workbook to prepare for a meeting.  Because of the nature of my work, these workbooks would often have a ton of tabs.  It was important for me to be able to get through the workbook quickly, and doing so with shortcut keys was always faster than using the mouse.

Cell Selection

CTRL + DIRECTIONAL KEYS    (Move to end of filled in values)
CTRL + SHIFT + 8    (Select entire table based on current cell selection)
SHIFT + SPACE    (Select entire row)
CTRL + SPACE    (Select entire column)
Cell Selection Shortcut
Similar to moving between tabs, cell selection, or moving around within the tab itself, is also a very important skill to have.  Being able to navigate and select cells quickly will improve both your efficiency at Excel and your confidence in using the tool.  Additionally, if you’re ever put in a situation where your colleagues are watching you use Excel, it’s a great idea to have these shortcuts handy if you need to impress them.
Coming up with just eight Excel shortcuts is difficult because there are so many good ones out there that were left off of this list (like ALT → E → S → V → ENTER).  What are your favorite, most impactful, Excel shortcuts?  Let me know in the comments section.

Comments

Popular posts from this blog

Google is using machine learning to teach robots how to grasp random objects

Using your hand to grasp a pen that’s lying on your desk doesn’t exactly feel like a chore, but for robots, that’s still a really hard thing to do. So to teach robots how to better grasp random objects, Google’s research team  dedicated 14 robots to the task . The standard way to solve this problem would be for the robot to survey the environment, create a plan for how to grasp the object, then execute on it. In the real world, though, lots of things can change between formulating that plan and executing on it. Google is now using these robots to train a deep  convolutional neural network  (a technique that’s all the rage in machine learning right now) to help its robots predict the outcome of their grasps based on the camera input and motor commands. It’s basically hand-eye coordination for robots. The team says that it took about 3,000 hours of practice (and 800,000 grasp attempts) before it saw “the beginnings of intelligent reacti...

eGym raises $45M Series C for cloud-connected gym equipment and fitness software

eGym , the Munich-based startup that offers cloud-connected gym equipment and supporting cloud software and app for the fitness training floor, has closed $45 million in Series C funding. The round was led by new investor HPE Growth Capital, while existing investors, including Highland Europe, also participated. The problem that eGym is looking to solve is that, whilst gyms have moved from a bodybuilder market to a mass market in the last 20 years, the technology in gyms lags behind. That’s despite the fact that better use of technology can help to reduce customer churn, the biggest pain-point of both gym operator and gym users. Comprising of an app for both gym user and trainer, combined with the company’s connected strength machines, the eGym Cloud makes it possible for gym members to receive better fitness instruction and an evolving and personalised fitness plan based on data collected as they workout. And by providing a better workout feedback loop, gym goers can get an i...

Here Are The First Connected Home Devices For Apple’s HomeKit

Apple’s HomeKit is finally starting to roll out to actual consumers, via the first crop of HomeKit-enabled accessories from third-party manufacturers. This means you’ll soon be able to get your hands on a range of products for the connected home that work with Siri on your iOS device, and that you’ll be able to do so as soon as today, since some of the new HomeKit accessories start shipping now. The accessories in question range from sensors, to lights, to thermostats, to smart outlets, and come from a group of accessory-makers with a trusted reputation in the connected home industry. HomeKit may have taken a while to arrive, but it’s doing so in grand fashion, with a practical lineup to get your home connected to your iOS ecosystem in an essential way. Elgato Eve The  Elgato Eve  is a set of connected wireless sensors that monitor key factors like indoor air quality, temperature, humidity as well as conditions outside, like temperature, humidity and air pre...

How to Run Older Applications in Windows 10

You cannot expect all the vendors to upgrade their programs to make them compatible with Windows and neither would you want to purchase all the applications every time a new version of Windows is out. Nonetheless, the fact still remains the same that not all applications are compatible with the latest operating systems and there are times when many applications do not initialize when you upgrade your PC to a newer version of Windows. To make things easy for you, Windows 10 allows you to run the programs in compatibility mode. Running a program in compatibility mode makes the application think that it is installed on an older, compatible version of Windows, thus the software runs without any flaws. There are two ways you can run a program in compatibility mode: Program Compatibility Troubleshooter – This is a step-by-step wizard that allows you to pick a program that you prefer to use and configures it to run in compatibility mode. Compatibility Tab – This tab can...

5 Best Free Antivirus for Android Phones and Tablets

Android mobiles are trending today. World is running behind android and its versions. I am sure you also having one high end android mobile with you.  So, here in this article I’ve listed the best 5 antivirus for Android phones and tablets. 1-  AVG Antivirus App For Android When you download AVG Anti-virus and install it on your mobile or tablet then it shows screen alert. By touching the screen you can perform the scan. It is a free anti virus software, which helps you to protect your mobiles from virus, malware and spyware It provides some other features like ANTI THEFT, SMS SCANNER, TASK KILLER etc. It protects your mobile when you use internet Download AVG anti-virus from ANDROID MARKET. 2-  Look Out Mobile  Antivirus Look out anti virus for mobile is one of the best android anti virus software. It keeps your tablets and phones safe and secure You can run the app any time and scan for virus It protects your mobile when you use interne...