Have you ever stared in awe as you watched a blur of fingers pull off tasks in Microsoft Excel at break neck speeds while you opt to complete similar tasks through using the mouse? The speed and accuracy experienced spreadsheet jockeys can achieve is no accident but through the picking up of keyboard shortcuts which can hasten the most complex of tasks.
But how do you leave the dependence of your trusty mouse and make the move over to becoming one of the Excel power user elite? Like anything it’s practice, but without knowing what to practice you may never get off the ground. This is why we have put together this handy tip sheet of some of our favourite keyboard navigation shortcuts for Excel 2007 to get you started. Once you have got the navigation down then we can get into some of the more meaty tasks such as functions, formatting and cell manipulations, but first give these a try and see if it speeds up your work.
|+ +||Once a row has been selected press these three keys together to insert a new row or column|
|+||Select a column|
|+||Select a row|
|+||Quickly move to the edge of your data range in the direction you press the arrow key|
|+||When selecting cells you can add additional cells one at a time|
|+||Auto-complete the cell you are in and automatically select the cell above|
|+||Auto-complete the cell you are in without moving to another cell|
|Auto-complete the cell you are in and moves down to the next cell|
|+||Takes you back to the beginning of the worksheet|
|+||Gives you a new line within the existing cell to write in|
|+ +||Select all cells going back to the beginning of the worksheet|
|+||Quickly shifts the screen along to the right to the next part of the worksheet. For example, by pressing this on cell A1 you will be shifted to AB1. Pressing “page up” will move the worksheet to the left|
|+||Sends you to the next sheet (the tabs at the bottom of the sheet). Use “page up” to skip to the worksheet to the left|
|Move to the next cell on the right. Hold shift to move to the left|
|+||Switch between open Excel files. Press this while holding “Shift” to toggle between files in the reverse order|
|+ +||Select everything in the worksheet|
|Clear the anything in the cell. Press this when multiple cells are selected to remove data from all selected cells|
We will be posting more Excel shortcuts in the future, so keep your eyes peeled, but for now why not look at some more of our Time Saving Tips for Excel.