Wednesday, January 19, 2011

How to Select Multiple Cells in Microsoft Excel 2003


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.

Blogger news