13 Microsoft Excel Tips
Brace yourself, for this nugget of knowledge: How to automate column width?
- Right click your worksheet title at the bottom of your document
- Click ‘View Code’
- Ensure the first drop down is ‘worksheet’ and not ‘general’
- Enter: Cells.EntireColumn.Autofit
- 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:
- CTRL + Enter = Repeat Text. Highlight an entire set of cell, type what you want to be repeated and then hit Ctrl + enter.
- Shift + F11 = Insert a new sheet.
- Ctrl + 1 = Quick formatting. Click Ctrl + 1 to quickly format highlighted cells.
- Shift + Ctrl + + = Add rows or columns. Select a column letter or row number and click shift ctrl + to add a new one.
- Ctrl + ; = Quickly insert todays date.
- Ctrl + space = select the current column
- Shift + space = select the current row
- Ctrl + tab = flick between the spreadsheets you have open
- Alt + f2 = open save as
- Ctrl + shift + ! = apply the thousands comma with two decimal places to data
- Ctrl + shift + $ = apply currency to data
- Ctrl + shift + % = apply percentage to data
- 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.
Browse more articles from our experts and discover how to make better use of IT in your business.