Selecting an area in a worksheet is a trivial task. Usually, it does with the mouse. A left-click is carried out over one of the four corner cells of the area intended for selection, and when the button is held down, the entire area is captured (the area is highlighted in color except for the corner cell). In fig. illustrates the process of allocating a range of cells A1: E8.
Suppose you need to select an entire row of cells or a column. In that case, the mouse cursor is moved to the row numbering strip or the column indexing strip, respectively (the mouse cursor takes the form of a horizontal or vertical arrow), and then the left mouse button is clicked. As a result, the entire row or column is selected. In fig, the line is highlighted.
The document with the highlighted column can be seen in the Figure below.
To select the entire worksheet (sometimes such a need arises), move the mouse cursor over the intersection of the row and column numbering strips in the upper left corner of the workspace. After clicking, the worksheet is highlighted.
Finally, it is often necessary to select several areas at once in different parts of the document. For example, you do this when you apply a common format to cells or ranges of cells that are not compactly laid out across the document. To not use the format to each cell or area separately, they are all selected at once, and then the format is applied. The recipe, in this case, is simple – cells and ranges of cells are chosen sequentially one after another. However, it would help if you held down the <Ctrl> key. In fig. below shows a situation where a range of cells A1: E8 is selected in a worksheet and the 9th row and column G.
Note that some operations are successfully performed using the keyboard. Some of the methods are described below.
Dinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular