How to Select Range Of Cells

When we are working with Excel we may sometimes need to select cells in a range or cells that are scattered in different rows and columns, at that time may do one of the following.

To select cells in a range:

1) Click on the first cell and hold the left mouse button and move over the required range of cells or press Shift key after clicking on a cell and use navigation keys to select the required range.

We will see a while 3d 'plus' symbol when we select something. In a similar way we can select even row or column.

2) To select multiple cells at a time without selecting the cells in between them we need to press Ctrl and click on the cells that are to be selected.

Posted in: Microsoft Excel 2003,Microsoft Excel 2007,Microsoft Excel 2010,Microsoft Office Support,PC Support,select multiple cells each,Selecting a range of cells,Technical Support,TechSupp247