Australian based Managed IT support offices in Melbourne, Sydney and Brisbane
Powernet Colour a VITG Company POS

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:

CTRL + D: Duplicate Cell

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. 

ALT + ENTER: Start a New Line in The Same 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. 

ALT + =: Insert Total Sum

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. 

CTRL + Spacebar: Select The Entire Column

Rather than using your mouse to click the column header, use this Excel shortcut to automatically select the entire column you're working in.

Shift + Spacebar: Select the entire row

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.

CTRL + : : Insert Current Time 

Use this shortcut to insert the time in the selected cell.

CTRL + ;: Insert Current Date 

Use this shortcut to insert today's date in the selected cell.

CTRL + Shift + #: Change Date Format 

Once you have inserted the current date, use this shortcut to change the format. 

CTRL + Shift + $: Apply Currency Format

Use this to format the selected cell as a currency.

CTRL + Shift + $: Change Currency Format

Another formatting shortcut (so handy!), use this one to change the format of currency within the selected cell. 

CTRL + Shift + %: Apply Percentage Format

Use this to format the selected cell as a percentage. 

CTRL + Shift + &: Apply border to selected cell/s

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.

CTRL + H: Find and Replace

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!

CTRL + Enter: Enter The Same Data in Multiple Cells

This shortcut helps you enter the same data in multiple cells very quickly! 

CTRL + 9: Hide The Selected Row/s

Need to hide a row from your workbook? This shortcut will do the job for you.

CTRL + 0: Hide The Selected Column/s

In the same fashion as hiding rows, use this shortcut to hide the selected column/s.

ALT + H + H: Select a Fill Colour

Need to fill the selected cell/s with a colour? Use this shortcut to access the colour fill menu. 

ALT + 7: Add Bullet Points Within a Cell

Did you know you can make a bullet point list within a cell? Use this Excel shortcut to get started. 

Text to Columns

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:

  1. Select the whole column with the data 
  2. Navigate to the 'Data' tab 
  3. Select 'Text to Columns'
  4. Choose 'delimited' or 'fixed width' (delimited is easiest if you have a space between first and last names)
  5. Choose where Excel splits the column, be it by space, comma, or another character 
  6. Hit next then finish!
Excel text to columns

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!

Subscribe to our newsletter for the latest technology tips & tricks.

Recent Articles

Tags

Categories

Search the Powernet blog

The Most Common Issues We Encounter on the Helpdesk and How to Fix Them

The Most Common Issues We Encounter on the Helpdesk and How to Fix Them

On a busy IT helpdesk, no one day is the same. There are a multitude of different reasons clients call […]

Read more
'The Importance of Reliable IT Support for Australian Businesses'

'The Importance of Reliable IT Support for Australian Businesses'

Amidst the dynamic landscape of technological advances, every business, whether big or small, needs effective IT in place. Using a […]

Read more
Staying Cyber Safe, Top 10 Tips for Being Cyber Secure

Staying Cyber Safe, Top 10 Tips for Being Cyber Secure

The importance of Cyber Security What is Cyber Security – Cybersecurity is the practice of protecting computers, servers, electronic systems, […]

Read more

We are well awarded

Reach our team

We’re always happy to help you find the right solutions to your IT and technology needs. Here are some ways to contact us.

Give us a call

Chat with our team to discover the best IT solutions for your organisation.
1300 892 692

Our locations

Melbourne CBD

Level 15 / 565 Bourke Street, Melbourne VIC 3000

Eastern Melbourne

Level 2 / 74 Doncaster Road, Balwyn North VIC 3104

Geelong Region

East 4/13-35 Mackey Street, North Geelong VIC 3215

Sydney

U18 / 23-31 Bowden Street,
Alexandria NSW 2015
(02) 8214 8855

Brisbane

7/9 Archimedes Place, Murarrie QLD 4172

Send us an enquiry

cross