Page 81 - Viva ICSE Computer Studies 7 : E-book

Learn More

Undo command cancels the last action that you performed in your worksheet. Redo command
on the other hand cancels the Undo command and retrieves the last action.

Using AutoFill Feature
Think and Discuss
AutoFill is a very useful feature available in Excel. This
Which shortcut key is used to
feature fi lls cell data or series of data into a selected
display the Delete dialog box?
range of cells in a worksheet. Excel compares the
selected data and tries to fi nd
out the next values that will be
inserted. Follow these steps to
use the AutoFill feature.
Step 2
1. Fill data in two cells and
Step 1 Step 3
select them.
2. Click on the Fill button in
the ‘Editing’ group of the
‘Home’ tab.

3. Click on the Series option
in the list.
4. Select AutoFill option
under the ‘Type’ heading
in the ‘Series’ box and click
on the OK button. Now
Step 4
drag the selection to fi ll
the cell where you want to
fi ll your data in.

Custom Lists

Custom List option helps in creating user defi ned lists and saves the time.

Follow these steps to create a custom list.

1. Click on the File tab.

Step 1

69