Categories
Excel Training

Speeding up data entry with Excel Shortcuts

I love shortcuts, they save me loads of time by using a couple of keystrokes instead of going to different tabs and menus.

Here are my 10 favourite Excel shortcuts to speed up data entry in Excel.

  1. To undo the last action – use Control + Z  no matter what program you are using, this shortcut undoes the last action.  Love it!
  2. To add today’s date –  use Control + ;
  3. To add the current time – use Control + Shift + :
  4. To edit a cell – use F2
  5. To select a column – use Control + spacebar
  6. To select a row – use Shift + spacebar
  7. To get to the last active cell in your Excel sheet – use Control + End
  8. To move to the first active cell – use Control + Home
  9. To move to the next worksheet – Control + page down
  10. To move to the previous worksheet – use Control + page up

For more time-saving shortcuts and techniques, Excel training can help give you the edge https://www.stl-training.co.uk/excel-2007-introduction.php

 

 

 

By Richard Bailey

I love what I do; I get to work with an outstanding team to help hundreds of people with their challenges. I’ve learnt a lot from the teams I’ve worked with, no matter the size or industry we all have challenges to overcome, difficult customers, creating a budget or keeping a project on track.