Home » Resources » Excel 2007 Tutorial » Highlighting Cells

In the last section we explored how to select one cell at a time, however there are times when you might want to select a group (or “range”) of cells together. All of this is covered in our Beginners Excel Training Course.

There are two ways to do this. The first is to simply press and hold the left mouse button and then drag the curser over the area which you which to highlight.

The second way is to highlight one cell (for example A1), and then press the F8 button on your keyboard. When you have done this the “Extend Selection” notification will appear on you status bar. Now select the last cell you which to highlight by clicking on it with your left mouse button and the computer will then highlight all the cells in between those two points. For instance if you click on A1 then E13 then all the cells between those two rows and columns will now be selected. Try it now!

In order to highlight more than one seperate area at a time you can hold down “Ctrl” whilst using the dragging technique described earlier. Also if at anytime you want to completely clear your spreadsheet of all highlighted areas then press Esc.

Similar resources you may like

1. Spreadsheets
2. Getting Moving
3. Submitting Information
4. Auto Sum
5. Customising Borders and Cell Size

Tags

course, data, Excel, Excel 2007 Tutorial, Free, highlighting cells, microsoft, microsoft excel, microsoft office, resource, sheet, spreadsheet, Tips, top Tips, training

Share This Resource

This entry was posted by Alistair Wylie on Friday, May 1st, 2009 at 5:05 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.