Page 77 - Computer - 6

3. Select the new location where you want to paste the contents.
4. On the Home tab, click the Paste button in the Clipboard
group. 4
Excel copies or moves the contents of the selected range
of cells to the new location.
5. Press the Esc key to deselect the cells.
Time Saver

3
Copy: Ctrl + C Cut: Ctrl + X Paste: Ctrl + V

Roundabout
Roundabout Subject Enrichment
You can also use drag and drop method to copy or move contents

of a cell or range of cells.

1. Select the range of cells you want to copy or move. 1
2. Move the mouse pointer over any border of the selected
cells. The mouse pointer changes to the pointer.

3. To move the contents of the cells, drag the selection and
drop it at the new location. 3
4. To copy the contents of
the cells, keep the Ctrl key
pressed while dragging the
selection and dropping it to
the new location.
4

Knowledge Discovery Subject Enrichment

You can also right-click the selected cells and select Copy, Cut, and Paste options from the context menu.

Creating Custom Lists 3
You can create your own list of values that can be used
with the AutoFill feature to fill a range of cells. Such a
list of values is called a Custom list.
To create a custom list:
1. Type the required list of values in consecutive 1
cells in a row or column.
2. Select the cells containing the values. 2
3. Click the File tab.

4. Click Options in the Backstage view.
The Excel Options dialog box opens. 4

75