10 Easter Excel Tips that will leave you wanting more!

1. Use F4 to make a cell absolute instead of typing $ when creating a formula (press F4 multiple times to make only part of the reference absolute)
2. Use Name Ranges in formulas? Press F3 to paste a name into a formula
3. To wrap text in a cell press Alt Enter e.g First Alt Enter Name would wrap First Name to display on 2 lines
4. To edit the current cell press F2
5. To jump to the top or bottom of a sheet press Ctrl Home or End
6. To select to the end of a list, position the active cell where you want to select from and press Ctrl  Shift  End
7. To view formulas on a worksheet press Ctrl and the key immediately underneath the Esc key on the keyboard
8. To insert the current date press Ctrl ;
9. To create a chart, highlight the data and corresponding column/row labels and press F11
10. To quickly copy a sheet, hold down Ctrl and drag the sheet and drop it immediately to the right

Look forward to seeing you soon,

Anita Lund
Owner and Founder of Trainers Direct Pty Ltd (Sydney)  
www.trainers-direct.com.au
​
& Storm Training & Solutions (UK) www.stormtraining.com