It’s often the little things that save the most time particularly if you are doing these things on a regular basis. These may not be the most flashy of features but they are the biggest time savers for the things that I do all the time.
Best Fit Columns
Often when I enter data into Excel the columns are not the right width for the data I am using. I could manually adjust each one separately but by selecting the whole spreadsheet I can best fit them all in one go.
- Select the whole spreadsheet by clicking on the triangle at the top left of the sheet
- Hover between any 2 column headings until the cursor becomes and double ended arrow and double click.
All the columns will now be fitted to the data in one go. This method can also be used on the rows by hovering between the row numbers instead.
When you are autofilling or copying a calculation you may need to fix a cell so it doesn’t move. This is called absolute referencing. It can save a lot of time by avoiding lots of manual intervention.
- Click in the cell containing the calculation
- Click in the part of the calculation that you need to fix
- Hit the Function key F4. This will put $’s in the cell reference e.g. $A$1 which fixes the cell
As long as the data is stored in a table with no blank rows or columns and headings in the top row then quick sort is a cracker.
- Click in the column you want to sort by
- Click on the Data tab and the Sort ascending or Sort descending icons depending on which order you require
NOTE: These work with text, numbers or dates.
If you have set up a format in a cell or range of cells then realise that you need to reuse that format elsewhere then the format painter is great.
- Select the cell that has already been formatted
- Click on the Format Painter icon
3. Select the cell(s) you want to apply the format to
NOTE: If the format painter icon is double clicked it can be used repeatedly and when you are finished you click on the icon once to turn it off.
Copy and Paste
Copy and paste avoids information having to be retyped but my real time saver here is using the keyboard shortcuts to perform the task.
- Select the cell(s) to be copied
- Press CTRL + C to copy
- Select the cell(s) where you want the information to be repeated
- Press CTRL + V to paste
I hope that these favourites of mine are useful to you too.
If you’ve enjoyed reading about my top 5 time savers in Microsoft Excel, there’s some other blogs below that you might find useful: