13 Microsoft Excel Shortcuts

Picture this: you're racing against the clock, struggling to meet deadlines and drowning in a sea of spreadsheets. But what if I told you that a simple keyboard shortcut could be the game-changer you've been yearning for?
15.12.23 Charles Griffiths

Brace yourself, for this nugget of knowledge: How to automate column width?

  1. Right click your worksheet title at the bottom of your document
  2. Click ‘View Code’
  3. Ensure the first drop down is ‘worksheet’ and not ‘general’
  4. Enter: Cells.EntireColumn.Autofit
  5. Close the code box down and Voila!

Don’t worry, there’s 13 more shortcuts for Excel in my 3 minute video above.

Boost Productivity with these Microsoft Excel Tips

Microsoft Excel is a powerful spreadsheet software that offers a multitude of features to help you organise, analyse, and visualise data. Whether you’re a beginner or an experienced user, these tips can help you become more efficient and proficient in Excel:

  1. CTRL + Enter = Repeat Text. Highlight an entire set of cell, type what you want to be repeated and then hit Ctrl + enter.
  2. Shift + F11 = Insert a new sheet.
  3. Ctrl + 1 = Quick formatting. Click Ctrl + 1 to quickly format highlighted cells.
  4. Shift + Ctrl + + =  Add rows or columns. Select a column letter or row number and click shift ctrl + to add a new one.
  5. Ctrl + ; =  Quickly insert todays date.
  6. Ctrl + space = select the current column
  7. Shift + space = select the current row
  8. Ctrl + tab = flick between the spreadsheets you have open
  9. Alt + f2 = open save as
  10. Ctrl + shift + ! = apply the thousands comma with two decimal places to data
  11. Ctrl + shift + $ = apply currency to data
  12. Ctrl + shift + % = apply percentage to data
  13. Ctrl + shift + & = apply outside border to data

Keyboard shortcuts 2, 5, 6, 7, 10, 11, 12, and 13 can be used for Google Sheets.

Related insights

Browse more articles from our experts and discover how to make better use of IT in your business.

Resources
Whitepapers
big data in manufacturing

Secure your data under lock and key

10.02.24

Data is the lifeblood of your business. That might sound dramatic but think about it for just a moment. It’s everything from customer profiles and financial transactions to confidential business plans and intellectual property. Read More

Resources
Tech Tips
Bright Coloured Laptop

How to enable Multiple Desktops in Windows

19.01.24

At AAG, we provide you with everyday tech tips to help optimise productivity when it comes to IT and technology. Here are 3 tips you can start using today. Read More

Resources
Tech Tips
focus

How to turn off distractions in Microsoft Word

12.01.24

Pop-ups, notifications, teams calls, and funny cat memes, can take your focus away from the document you're working on. Turn on focus mode. Read More