How to Select Multiple Cells in Microsoft Excel 2003

Many people use spreadsheet software as a means to keep track of their daily finances and budgets. Freelancers use it for billing and payment and invoice tracking. One of the more notable features in the advanced spreadsheet software applications of today is the ability to highlight and select multiple cells at once and make amendments or additions to them.

Things You'll Need

• Microsoft Excel 2003

Instructions

1. Highlight the cells. Use your mouse cursor and left-click on the first cell and then hold the button in as you drag the cursor over the cells you wish to select. Once you are done selecting cells you can release the mouse button and the cells will remain highlighted.

2. Select multiple cells using hot keys. You can also use hot keys to select multiple cells. To do this, press the “CTRL” key and hold. While pressing “CTRL,” left-click on the cells that you wish to select. They will gray out when you select them. Release the “CTRL” key and the cells that you selected will remain highlighted.

3. Use the “Go To” command to select cells. To use the “Go To” command to select cells scroll to the “Edit” tab on the command bar and select “Go To.”

4. Enter cell references to select cells. To select multiple cells you will need to enter the cell references in the “Go To” properties box. For example if you wanted to select cells A1 and B3 you would enter A1, B3. To select a span of cells in the same letter you could enter B1:B9, which would select all of the cells in that sequence.