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

So, when will your device actually get Android Oreo?

Google officially just took the wraps off of Android Oreo, but there are still some questions left to be answered — most notably, precisely when each device will be getting the latest version of the mobile operating system. Due to Android’s openness and a variety of different factors on the manufacturing side, it’s not an easy question to answer, but we’ll break it down best we can. First the good news: If your device was enrolled in the Android Beta Program, you’ll be getting your hands on the final version of the software “soon,” according to Google. Exactly what that means remains to be seen, but rest assured that you’ll be one of of the first people outside of Google to take advantage of picture-in-picture, notification dots and the like. No big surprise, Google handsets will be the first non-beta phones to get the update. The Pixel, Nexus 5X and 6P are at the top of the list, alongside Pixel C tablet and ASUS’s Nexus Player set-top box, which will be receiving the upgrade i...

Get 56GB of free cloud storage in one folder!

Bring Your Box, Dropbox, Google Drive, & OneDrive All Together In One Folder With odrive! Dropbox gives you up to 16GB free.  Google Drive & Gmail give you 15GB. OneDrive gives you 15GB. Box gives you 10GB. odrive brings all your cloud storage apps together in one folder right on your desktop. Just link your Dropbox, Google Drive, Gmail, Box, and OneDrive accounts to odrive and instantly get all your files scattered everywhere in one place! You can even link multiple accounts from each app to get even more! 1. Install odrive. DOWNLOAD It's free! And available for Windows & Mac :) 3.Get all your stuff! 2. Link all your cloud storage accounts. Note:  This gives odrive permission to download your files for you. odrive doesn't store anything, we promise! OXYGEN CLOUD, INC., 1600 SEAPORT BLVD, REDWOOD CITY, CA, 94063, UNITED  ...

Shatterproof screens to protect smartphones

Polymer scientists at the University of Akron in Ohio have developed a transparent electrode that could change the face of smartphones, literally, by making their displays shatterproof. In a recently published paper, researchers show how a transparent layer of nanowire-based electrodes on a polymer surface could be extraordinarily tough and flexible, withstanding repeated scotch tape peeling and bending tests. This could revolutionise and replace conventional touchscreens, according to Yu Zhu, UA assistant professor of polymer science. Currently used coatings made of indium tin oxide (ITO) are more brittle, most likely to shatter, and increasingly costly to manufacture. “These two pronounced factors drive the need to substitute ITO with a cost-effective and flexible conductive transparent film,” Zhu says, adding that the new film provides the same degree of transparency as ITO, yet offers greater conductivity. The novel film retains its shape and functionality after tests i...

Windows 10 for phones will be released on this Friday

Microsoft's head of the Windows Insider program, Gabe Aul, has announced today on Windows Weekly that they will release a  new build of Windows 10 for phones  on Friday at 10 AM PT. Windows 10 release date A few weeks back, the company announced a new list of supported devices for the next release but for the version that will be released on Friday, the Lumia Icon and Lumia 930 will not be supported. Gabe said during the announcement that it came down to the new UI being too small on these devices and as such, will not be included in this release. List of supported devices Lumia 1020 Lumia 1320 Lumia 1520 Lumia 520 Lumia 525 Lumia 526 Lumia 530 Lumia 530 Dual Sim Lumia 535 Lumia 620 Lumia 625 Lumia 630 Lumia 630 Dual Sim Lumia 635 Lumia 636 Lumia 638 Lumia 720 Lumia 730 Lumia 730 Dual SIM Lumia 735 Lumia 810 Lumia 820 Lumia 822 Lumia 830 Lumia 920 Lumia 925 Lumia 928 Lumia ICON Microsoft Lumia 430 Microsoft Lumia 435 Microsoft Lumia 435 Dual SIM Microsoft Lumia 435 Dual ...

Facebook Messenger For Apple Watch Officially Launches

During Apple’s keynote in September, they announced that Facebook Messenger would be coming to the Apple Watch, as long as you’ve updated to watchOS 2. Well, it’s here.   You can now share things like voice clips, likes and stickers from your Apple Watch. From my experience, little interactions like this are what works best on the Watch. I’ve found that as soon as I have to do anything more than pick a person and an action, things go haywire. Sure, there’s a lot more to do with watchOS, but I’d say that 2 is lightyears ahead of what the device shipped with. When Messenger for Apple Watch was first announced, our own Josh Constine said: The more platform ubiquity Facebook Messenger can achieve, the stronger its network effect will be entrenched. Each time a friend messages you from Facebook Messenger, it draws you closer to the Facebook ecosystem. Each time they text you from SMS or another app (other than WhatsApp), it pulls you further away. That’s why despit...