Page 69 - TrackpadV1.0_C5_Flipbook
P. 69
In the previous chapter, we have learnt how to open Excel, how to enter data, how to
select it, and also learned about working with worksheets. In this chapter, we will learn
more about Excel.
SELECTING A RANGE OF CELLS
Let us learn how to select a range of cells.
To select a row:
SELECTING A CELL
To select a cell, click on the cell. It will become the active Short key Ctrl + Alt +
cell and a green border appears around it. You can also
use the arrow keys to move to change the active cell. or
SELECTING A ROW
Click here to select an entire row
To select a row, place the mouse pointer on the row header of the
row to be selected. The mouse pointer will change to an arrow. Now Click here to select
entire Column
click on the row header and the entire row gets selected.
SELECTING A COLUMN
To select a column, place the mouse pointer on the column header
of the column to be selected. The mouse pointer will change to an
arrow. Now click on the column header, the entire column gets
selected.
Or
Press Ctrl + Shift + Up/Down Arrow key on the keyboard.
RANGE OF CELLS
We might want to select more than one cell at a time to
perform a certain task. When we select more than one cell
at a time, these contiguous (adjoining/connected) cells form
a range.
We can select a range of cells with the help of:
Editing in Excel 2010 67

