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
Tech Tips
Microsoft Copilot

How to use Microsoft Copilot in Outlook

06.06.24

Managing emails efficiently can be a daunting task. Copilot in Outlook can enable you to catch up, prepare and follow up with ease. We show you how to get the best out of Copilot in Outlook. Read More

Resources
Tech Tips
How to use Copilot in Excel

How to use Microsoft Copilot in Excel

06.06.24

Managing huge data sets and organising multiple spreadsheets is often time-consuming and tedious. Microsoft Copilot offers teams a powerful tool for streamlining data analysis and range of other tasks within Excel - we show you how. Read More

Resources
Tech Tips
How to use a whiteboard in Microsoft Teams with Copilot

How to use a Whiteboard with Copilot in Microsoft Teams

06.06.24

Managing emails efficiently can be a daunting task. Copilot in Outlook can enable you to catch up, prepare and follow-up with ease. Read more. Read More