9 Excel Shortcuts You Need to Know

Excel Example

I wish I had known in college just how crucial Excel skills are in the workforce. Not just in the business world, but also in industries such as media, tech, engineering…the list goes on. Data analysis is becoming a critical component in just about every job thanks to advances in data storage technology. Excel is a basic skill every working professional should have in their tool belt – and today I’m sharing 9 Excel shortcuts, or hot keys, that will help you out on any Excel quizzes you may face during interviews, save you time, and impress your boss.

Today, we’ll be using a sample spreadsheet I created. Place yourself in the shoes of a compensation analyst who is looking at the compensation data of employees at a company. You’ve just received a request to pull some data on a subset of employees, and you don’t have a lot of time. Now you get to put your Excel hotkeys to use – let’s get started!

 

 

  1. Selecting an entire row (SHIFT + SPACE)

This shortcut is particularly useful if you want to focus on or isolate a particular row of data, which usually shows all the data components linked to one attribute (usually an employee, customer, etc.) in your spreadsheet.

Select Row

 

  1. Selecting an entire column (CTRL + SPACE)

This shortcut is helpful when you want to focus on one column in your spreadsheet – perhaps to copy the contents of that column or perform a search for a specific characteristic.

Select Column

 

  1. Selecting an entire table (CTRL + SHIFT + ARROWS)

Selecting an entire table with just a few keystrokes is a huge time saver. You may want to copy your table to paste it into a PowerPoint deck, or copy the formatting onto another similar table.

Select Table

 

  1. Moving through the different sheets in your workbook (CTRL + PAGE DOWN/UP)

This shortcut will help you navigate easily through your entire workbook – you can move through tabs without having to click through each one.

Toggle

 

  1. Creating a filter (ALT + D + F + F)

You could always click the “Sort & Filter” option under the Home tab in your top ribbon, but selecting your header row with Shift + Space and doing a quick Alt + D + F + F is often more convenient. The shortcut may not appear so short at first glance, but it becomes very useful when you’re crunching numbers under a deadline.

Create Filter

 

  1. Auto sum (ALT + =)

Let’s say, in our scenario as a compensation analyst, that we want to see what the actual spend was on total annual salaries. You could use a SUM() formula – or you could highlight the contents of your column and do an easy Alt + =, and voila! Instant sum. (Bonus Tip: you can also see useful statistics, such as Average, Count, and Sum on the bottom right hand corner if you select your column/row of interest).

Auto Sum

 

  1. Getting to the end or beginning of a row/column/table (CTRL + ARROW)

Sometimes, your data sheets may have dozens, maybe even hundreds, of columns and rows of data. To get from one end of a table to another (either column or row), use Ctrl + a combination of arrow keys and presto – you get get from Point A to Point B in a snap!

End to End

 

  1. Formatting your cell (ALT + O + E)

Odds are, you’ll be needing to clean up your table once you’ve manipulated all the data. One quick way to access the Format dialog box is pressing Alt + O + E, which will bring you right to all kinds of formatting options – don’t go too crazy now!

Format

 

  1. Sorting your data (ALT + D + S)

It might also be useful to sort your data in a logical way; for instance, in our example below, it might make sense to order our employees from highest to lowest salary so we get a sense of hierarchy. You can easily sort a table by selecting it (refer to Excel trick number 3) and then pressing Alt + D + S. You can add one or multiple rules to sort your data – nifty!

Sort

 

There are a ton of other nifty Excel shortcuts you can learn to save time. If you want, you can make it a goal for yourself to never touch the mouse – all my coworkers and I have accomplished this feat! Check out these awesome articles here and here for additional help. As always, shoot me a message or a comment below if you have any questions or want to learn more!

 

Keep on Crushin’,

Julie

10 thoughts on “9 Excel Shortcuts You Need to Know

    1. Hi Loree, thank you for your note! Excel is definitely a complex tool, but one that will always be useful in analyzing data! Let me know if you come up with any shortcuts you’d like to share :)
      -Julie

  1. Heya! I’m at work browsing your blog from my new iphone 3gs!
    Just wanted to say I love reading your blog and look forward to all
    your posts! Keep up the outstanding work!

    1. Hi Glinda, congratulations on your new iPhone! Thank you for your kind words – I will be posting new content at least once a week from now on, so I hope you’ll check back in regularly! Thanks for your encouragement :)
      -Julie

  2. I’m not that much of a internet reader to be honest but your sites really nice, keep it up!

    I’ll go ahead and bookmark your site to come back
    later on. Cheers

    1. Hi Meagan, thank you for your support and encouragement! It really means a lot to me that you would take the time to comment. I hope I’ll continue writing content that is useful – hope to see you again soon!
      -Julie

  3. This is such a helpful post! Thank you for taking the time to share some of your knowledge. Maybe you could make an advanced excel article next? Keep up the good work.

    1. Ryan, I’m glad you find the article helpful. Thank you for the suggestion – I will definitely look for more tips on advanced Excel tricks for one of my future posts. Hope to see you around :)
      -Julie

  4. I simply want to say I’m all new to weblog and definitely liked you’re blog site. Probably I’m going to bookmark your site . You definitely have wonderful article content. Many thanks for revealing your website.

    1. Thank you for your encouraging words! I’m glad you like my content and hope to see you back again soon. If you have any topics you’d like me to post on, let me know!
      -Julie

Leave a Reply

Your email address will not be published. Required fields are marked *