Keyboard shortcuts and tips to make spreadsheet work easier.
1. Print or copy the change history of a shared workbook
When sharing spreadsheet between colleagues, it can be handy to review what changes have been made.
1. On the Review tab, click ‘Track Changes’, and then click ‘Highlight Changes’
2. select the ‘When’ checkbox in the dialog box, then select ‘All’ from the list box
3. Clear the ‘Who’ and ‘Where’ check boxes
4. Select the List changes on a new sheet check box, and then click OK
5. To print the History worksheet, click ‘Print’
To copy the history to another workbook, select the cells you want to copy, click ‘Copy’, switch to another workbook, click where you want the copy to go, and click ‘Paste’
2. Keyboard shortcut: Toggle between formulas and results
Switch between Excel’s normal display – showing results of formulas in the spreadsheet – and a formula display mode to see what formulas are in place on your spreadsheet.
Click ‘CTRL’ + ‘ ‘ ‘ (grave accent)
3. Keyboard shortcut: Add the current date
This is a quick trick to save you having to write out today’s date.
Click ‘CTRL’ + ‘;’ (semi-colon)
4. TODAY function
If you need a worksheet to continually update itself, to the current date every time it is read, the TODAY function will do this by reading the computer’s serial date automatically.
1. Select the cell in which results will be displayed
2. Click on the Formulas tab and select ‘Date and Time’ to open a drop down list
3. Click on TODAY in the dialog box and click OK.
Type ‘=TODAY( )’ into the formula bar
5. Split text over lines within cells
If you are typing lots of information into one cell and want to split it over several lines to make it easier to read, do not click the entre key as this will move to the next cell down.
Click ALT + ENTRE