Almost all of us use Excel in one form or another and there are countless shortcuts and hacks to make your Excel experience more efficient.
We have compiled the top 20 Windows Excel shortcuts that you need to know:
My personal favourite. Pressing ctrl + D will duplicate the above cell, saves time with formatting, it will also copy any formula listed within the above cell.
My second favourite! Writing a lot of text in one cell? Use this short cut to start a new line within the same cell.
Have a block of data you need the total calculated for? By highlighting the block and and pressing ALT and = at the same time you will get the SUM. Just make sure you have a spare column on the right and at the bottom for your summarised data.
Rather than using your mouse to click the column header, use this Excel shortcut to automatically select the entire column you're working in.
In the same fashion as the above shortcut, instead of clicking the header for a row, you can use this Excel shortcut to select the entire row.
Use this shortcut to insert the time in the selected cell.
Use this shortcut to insert today's date in the selected cell.
Once you have inserted the current date, use this shortcut to change the format.
Use this to format the selected cell as a currency.
Another formatting shortcut (so handy!), use this one to change the format of currency within the selected cell.
Use this to format the selected cell as a percentage.
Rather than using your mouse to navigate through the menu bar, use this Excel shortcut to apply a border to the current selected cell or cells.
Use this Excel shortcut to replace a word or symbol or sentence that appears in your workbook. This is especially useful if you are replacing something that appears multiple times throughout a spreadsheet, including incorrectly capitilised words!
This shortcut helps you enter the same data in multiple cells very quickly!
Need to hide a row from your workbook? This shortcut will do the job for you.
In the same fashion as hiding rows, use this shortcut to hide the selected column/s.
Need to fill the selected cell/s with a colour? Use this shortcut to access the colour fill menu.
Did you know you can make a bullet point list within a cell? Use this Excel shortcut to get started.
Ok this one isn't a keyboard shortcut however, it will save you a lot of time! If you have a list of data that needs to be split into multiple cells, this tool is your friend! For example, you have a list of first and last names and need to split first name and last name into two columns. Here's how you can automate it:
There are countless shortcuts available in Excel, but these are our favourites. We suggest printing this article out and keeping it next to your keyboard while you're learning them and soon enough, you'll become a master of Excel keyboard shortcuts!
Want to share this with your team? Download the guide here: GET THE GUIDE HERE
Which are your favorites? Add a comment and let us know!
If you want to remove that stubborn blank page at the end of your report or delete a page containing […]
Read moreHow to Unsend an Email in Outlook “Have you ever experienced that sinking feeling in your stomach after accidentally sending […]
Read moreWe all spend a great deal of time in our internet browser, searching, googling, so it makes sense to not […]
Read more
