Datasheet

Chapter 1: Getting Started
17
To use your mouse to move a range of
cells, select the cells you want to move and
then point to the border of your selection.
When your mouse pointer turns to a ,
drag your selection to a new location.
To use your mouse to copy a range of cells,
select the cells you want to copy and then
hold down the Ctrl key while you point to
the border of your selection. When your
mouse pointer turns to a , drag your
selection to a new location.
2
4
5
1
3
CUT AND PASTE
1 Select the cells you want to move.
2 Click the Home tab.
3 Click the Cut button in the Clipboard group.
A dotted line appears around the selected cells.
4 Place the mouse pointer where you want to
paste the cells.
5 Click Paste in the Clipboard group.
•
Excel places the data in the new location.
You can select cells and press Ctrl+C to copy or Ctrl+X
to cut and then press Ctrl+V to paste.
When you cut or copy a range of cells that have
hidden rows or columns and then paste, Excel includes
the hidden rows and/or columns when it pastes.
If you want to copy only visible cells, select the cells
you want to copy. Click the Home tab. Click Find &
Select in the Editing group. A menu appears. Click
Go To Special. The Go To Special dialog box appears.
Click Visible Cells Only. Click OK. Press Ctrl+C. Move
to the Paste area. Press Ctrl+V.
04_132296 ch01.qxp 5/24/07 12:53 PM Page 17