Page 69 - 2422_C5_Flipbook
P. 69
To change the data partially, follow the steps: 3 2
Step 1: Click on the formula bar or double-click on the cell
where you want to edit the data. The cursor appears
in the cell.
Step 2: Enter the new data in the cell or the formula bar.
1
Step 3: Press Enter key or click on the Enter button on the
formula bar. The cell data is changed.
UNDO AND REDO COMMANDS
You use the Undo command to erase the last change made to the worksheet or your last
action. To undo click on the Undo button on the Quick Access Toolbar. If you wish to undo
many actions, click on the down arrow next to the Undo button .
Redo command is used to redo the last Undo action. Redo command works only when you
have given an Undo command. The Redo button on the Quick Access Toolbar stays inactive.
To redo an action, click on the Redo button on the Quick Access Toolbar.
COPY AND MOVE 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 2016.
Copy Data
To copy data, follow the given steps:
Step 1: Select the cells you want to copy. We have selected the range B3:C4.
Step 2: Click on the Home tab.
Step 3: Select Copy button from Clipboard group.
Or
Right-click and choose Copy option from the context menu or press Ctrl+C keys.
A dashed border appears around the selected cells. Notice that the range B3:C4 has
a dashed border around it.
Step 4: Click on the cell where you want to copy the selected range.
Step 5: Select Paste button in clipboard group.
Or
Right click and choose Paste option from the context menu or press Ctrl+V keys.
Editing Cell Contents in Excel 2016 67

