Page 69 - TP_Plus_v4_Class4
P. 69
CHANGING CELL CONTENTS
You can change the contents of a cell by following the given steps:
Click in the formula bar and enter the 1
new data in the cell or the formula bar.
Press Enter key or click on the 2
Enter button on the formula bar.
Hintbot
You can also change the data by double-clicking in the cell To edit a cell: F2 key
and start typing the new data. It activates the “editing”
mode for the active cell.
UNDO AND REDO COMMANDS
You use the Undo command to erase the last change made or last action done to the worksheet.
To Undo click on the Undo button in the Quick Access Toolbar. If you wish to Undo many
actions, click on the down arrow next to the Undo button and select the number of Undo Actions.
Redo command is used to redo the last Undo action.
Redo command works only when you have given an Undo Hintbot
command. The Redo button on the Quick Access Toolbar Shortcut to Undo:
stays inactive till Undo command is used. To redo an action, CTRL + Z
click on the Redo button in the Quick Access Toolbar. Shortcut to Redo:
CTRL + Y
COPYING AND MOVING DATA
You can easily copy and move the contents of a cell, a range of cells and an entire worksheet.
This is similar to the copy and move commands in Word 2019.
Copy/Move the Data
To copy/move the data, follow the given steps:
2
Click on the Home tab. Select Copy/Cut 3
command.
Select the cells you
1
want to copy/move.
Click on the cell
where you want
to copy/move. the 4
selected range.
#Editing Cell Contents in Excel 2019 67

