13 Microsoft Excel Tips

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 below.

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.

Sign up below for weekly tech tips directly to your inbox.