Saturday, July 2, 2011

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.


Post a Comment

Search This Blog


Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More