Top 10 tricks you didn't know in Excel 2013

Enterprise Applications

by Claire Vanner| 07 February 2014

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.

Directions:
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.

Directions:
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.

Directions:
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.

Directions:
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.

Alternatively:
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.

Directions:
Click ALT + ENTRE

Comments
Post a comment

Comments may be moderated for spam, obscenities or defamation.

Join our network

716 people like this.
1535 people follow this.

Enterprise Applications Intelligence

Suppliers Directory

Privcy Policy

We have updated our privacy policy. In the latest update it explains what cookies are and how we use them on our site. To learn more about cookies and their benefits, please view our privacy policy. Please be aware that parts of this site will not function correctly if you disable cookies. By continuing to use this site, you consent to our use of cookies in accordance with our privacy policy unless you have disabled them.