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