Some tips for Excel – shortcuts!

We all love a shortcut!  Here are a few in Excel to speed up your working!

1. CTRL A – select a range of data

 

2. CTRL SHIFT and END – Highlights from current cell to end of data.

 

3. ALT F5 – refresh the contents of a Pivot Table

 

4. To copy an entire sheet – If you want to move a sheet, you click and drag along the sheet tabs.  You probably know that!  However, holding down the CTRL key when you click and drag will copy the sheet.

 

 

Copyright © 2015-2018 Vue IT TrainingWeb Design by fairly marvellous Kent