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.

 

 

Filed Under: Excel

 

Please share:Share on FacebookTweet about this on TwitterShare on Google+Share on LinkedInEmail this to someone

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