Microsoft Office Tutorials and References
In Depth Information
When you select a single cell and drag the ill handle in any direction, Excel copies the
contents of that cell to all the cells through which you drag (with exceptions, which you’ll learn
later). When you select more than one cell, Excel either copies the range or extends a data
series in the direction you drag, depending on the cell contents, the shape of the
selection, and whether you are holding down Ctrl. Pressing the Shift key while dragging the ill
handle lets you insert blank cells into a worksheet.
In the worksheet at the top in Figure 8-16, we selected A7:G7 and dragged the ill handle
one row down while pressing the Shift key. The pointer became a double-headed arrow.
The worksheet on the bottom in Figure 8-16 shows the newly inserted blank cells.
You use the same technique to insert entire blank rows or columns—just select the row
or column headings, or press Shift and drag the ill handle, which appears adjacent to the
row or column headings. You can just as easily delete cells, columns, or rows using a similar
technique. To delete the cells we inserted in Figure 8-16, select A8:G8, hold down Shift,
and then drag the ill handle up one row. The area turns gray, and the pointer changes to a
similar double-headed arrow, with the arrows pointing inward this time. When you release
the mouse button, Excel deletes the selection.
Figure 8-16 Drag the ill handle while pressing Shift to insert cells.
If you drag the ill handle back over selected cells without pressing Shift, you clear the cell
contents instead of deleting the cells. This clears formulas, text, and numbers only. If you