Page 70 - trackpad v5.1 class 5 flipbook
P. 70
In the previous chapter, we learnt how to open Excel, how to enter data, and how to select
it, and also learnt 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 + Shift +
cell and a green border appears around it. You can also
use the arrow keys to move to change the active cell. Left/Right Arrow
SELECTING A ROW
Click here to select an entire row
To select a row, place the mouse pointer on the row header of the Click here to select
row to be selected. The mouse pointer will change to an arrow. Now 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.
68 Pro (V5.1)-V

