Page 21 - TP_Pluse_V2.2_Class_6
P. 21
We can also select a range of cells by using the Shift key. Click on the first cell and then press and hold
the Shift key down, and click on the last cell up to which we want to make a selection.
Unrelated or Discontinuous Cells: Click on the first cell to be selected then hold the Control Key
and continue selection of the unrelated cells while holding on
the Control key. Tech Hint
Entire Row/Column: Click on the row heading to select the To select entire worksheet:
entire row or click on the column heading to select the entire Ctrl + A
column.
Entire Worksheet: Click on the Select All button located below the Name box to select the
entire worksheet.
Modifying Cell Content
Excel provides two ways to modify or change the contents of a cell. One is editing the content in Edit
mode and the other is overwriting or replacing the entire content of the cell directly. To activate the
Edit mode and change the content of a cell, follow these steps:
Step 1: Create a new workbook and enter some data into a worksheet as similar to the given data.
Step 2: Double-click on the cell whose contents we want to change. The Edit mode is activated and a
blinking cursor appears in the clicked cell.
Edit
mode
Editing cell content
Step 3: We can now make the required changes. After making all the changes, press the Enter key
from the keyboard. The changed data is displayed in the cell.
Content after editing
To replace the entire contents of a cell, follow these steps:
Step 1: Click on the cell whose contents we want to replace.
More on Excel 2016 19

