Home » Resources » Excel 2007 Tutorial » Getting Moving

The first thing that you will need to learn is how to move around a Spreadsheet. One way of doing this is to use the arrow keys on your keyboard to highlight a particular cell. The highlighted cell has a thicker black border than the others. Using the arrow keys you can move the selected cell up, down, left or right one cell at a time. You can also use the page up or page down keys to move a whole page at a time. All of this is covered in our Beginners Excel Course.

It’s easy to lose track of where you are in a spreadsheet – at any time you can hold the “Ctrl” key the “Home” keys together to return the selected cell to the top left of the sheet (cell A1). If you are new at this then it is worthwhile practicing this for a few minutes before continuing so as to get a better feel for moving around.

For a quick and easy way to locate a cell press the F5 key. This will open the “go to” box, where in you can enter the address of the cell that you want to go to, and be taken there immediately. Alternatively, you may find it easier to use the left part of the Formula bar at the top of your spreadsheet. Just type the address of the cell (e.g A1 or C4 etc…) and press enter

Similar resources you may like

1. Spreadsheets
2. Highlighting Cells
3. Submitting Information
4. Basic Calculations
5. Altering and Moving your chart

Tags

course, data, Excel, Excel 2007 Tutorial, Free, graph, microsoft, microsoft excel, microsoft office, resource, sheet, spreadsheet, Spreadsheets, Tips, Tools, top Tips, training, Tutorial

Share This Resource

This entry was posted by Alistair Wylie on Friday, May 1st, 2009 at 5:03 pm and is filed under Excel 2007 Tutorial. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.