Top 10 Excel Keyboard Shortcuts

Last updated on October 4, 2017 By

(Note: this post was written by guest author Anabel Cooper)

Excel is probably one of the most powerful programs that’s readily available for working with data. Even if you’ve been working with Excel for quite a while, it always seems like there’s so much to learn about its endless possibilities and features.


I recently found a neat article written by Reuben Yonatan from GetVoip – and they were happy for me to share their infographic of 29 essential Excel hacks to make your life easier and more productive.


Further down this page you’ll see the full GetVoip infographic – and you can also get a free PDF download of the 29 essential Excel hacks below the list of Top 10 shortcuts.


I pulled out my top 10 useful Excel shortcuts – there’s something here for everyone, from beginner to advanced. And these work for both Windows and Mac Excel.

Here’s my Top 10 Excel Keyboard Shortcuts

Excel hacks like these save your precious time and nerves while working with large arrays of data or if you are a complete beginner in excel and want a few practical shortcuts to get faster and feel more confident.

1. Inserting column or row. This is one of the most popular requests of those who manage data. When you already have a few columns with precious data, but you decide that another one needs to be inserted between them, select a column and press Ctrl + Shift + = (Command + Shift + = for Mac).


2. Deleting columns and rows. Deleting a column or a row just takes a second if you select it and press Ctrl + Shift + – (Command + Shift + – for Mac). This shortcut is useful for salary spreadsheets, for instance, when you need to delete data about one employee who’s been fired.


3. Inserting current time and date. A very handy instrument for salespeople, who need to register the time of issuing a receipt. To insert current time into a cell, select the needed cell and press Ctrl + Shift + : (Command + Shift + : for Mac). To add today’s date, click Ctrl + ;


4. Starting a new line in the selected cell. Sometimes a cell contains a few sentences or names, and we need to put them into a column inside the cell. To start a new line inside a cell, put the cursor in the place where you want a new line and press Alt + Enter (for Mac, Option + Enter).


5. Opening search box. When you have massive arrays of data, it is important to be able to quickly access the search box to find what you need. To do that, go to the spreadsheet and click Shift + F5 (Shift + fn + F5 or Mac).


6. Navigating to the last cell. Again, this hack is for massive spreadsheets. Click Ctrl + End (Command + Arrow Key) to go to the last cell of the spreadsheet.


7. Selecting rows and columns. To select row, press Shift + Spacebar; to select column, press Ctrl + Spacebar. This is a basic step you need before using other shortcuts.


8. Hiding row and columns. This is useful when you need to work with two columns or rows at the same time that are not close to each other. To hide data between them, select the rows or columns you need to hide and press Ctrl + 9 for rows and Ctrl + 0 for columns.


9. Copying a formula into subsequent cells. Select a cell, click on the lower right corner and drag over the cells you need to fill with the same formula. Done!


10. Quickly formatting currencies. To access currency formatting quickly, highlight the necessary column and press Ctrl + Shift + $.


Get the free PDF download of 29 essential Excel hacks (courtesy of GetVoip):

HERE’S YOUR FREE PREMIUM CONTENT!
RIGHT CLICK THIS LINK AND SAVE AS …

Remember to check out the original GetVoip article here: getvoip.com/blog/2017/07/25/excel-hacks/


Get the free PDF download of 29 essential Excel hacks (courtesy of GetVoip):

HERE’S YOUR FREE PREMIUM CONTENT!
RIGHT CLICK THIS LINK AND SAVE AS …

Want to keep a copy of the infographic?

Get the free PDF download of 29 essential Excel hacks (courtesy of GetVoip):

HERE’S YOUR FREE PREMIUM CONTENT!
RIGHT CLICK THIS LINK AND SAVE AS …

Related Posts:


Connect on YouTube, LinkedIn, Twitter.

Hey, I'm Victor Chan

Are you struggling with complex Excel tasks? Feeling overwhelmed by spreadsheets that are hard to use?

Many people believe mastering Excel is about learning shortcuts, functions, and formulas. But this overlooks the importance of building practical, real-world applications. It's not just about knowing the tools. It's about using them effectively.

That's where I come in. You'll get a unique perspective to Excel training from me. I have over 20 years of experience at Deloitte and two global tech companies. And I know what can make a difference in your career.

Let me help you integrate Excel into your professional life. Starting today. Read one of my articles, watch one of my videos. Then apply the new technique to your work. You'll see the difference immediately!


Recommended Posts

Discover the PROVEN Blueprint for transforming your Excel skills, supercharging your productivity, and standing out in your career! My course helps you to learn Excel VBA and save hours of time even if you have zero prior experience with programming.

Solve tricky Excel problems and take your work to the next level! Get customized solutions for your unique needs. Save time and gain insights with truly expert Excel solutions from only $97 per task.

Get a clear overview of your project progress using the Excel project timeline. Use it to communicate the big picture, track task progress, and stay on top of your project goals. Stay organized with our project timeline!

Our cheat sheets provide quick and easy reference to commonly used Excel VBA concepts and code snippets.

Unlock new levels of productivity and efficiency with our cheat sheets, and write VBA code like a pro in no time.

RECOMMENDED READING

Are you looking to upskill and stay ahead of the curve? Excel is a powerful tool that keeps growing in demand. We round up the best online courses for learning Excel.

Are you looking to up your spreadsheet game? Excel is an invaluable tool that can help you stay organized and save time. From data analysis to budgets, Excel can do it all!

Today, having Excel skills is more critical than ever. Those who know how to use Excel are more likely to find higher-paying jobs. And get promoted faster.

JOIN FREE EMAIL NEWSLETTER

Step up your Excel game! Join our free email newsletter and get updates on how to become more awesome at Excel.