Microsoft Office Tutorials and References
In Depth Information
Inserting and Deleting a Range
Figure 1-18
Cells being inserted into a worksheet
new cells will be
inserted in this
selected range
inserted cells
selected range and
adjacent cells mov e
to the right
new cells will be
inserted in this
selected range
inserted cells
selected
range and
adjacent cells
move down
The process works in reverse when you delete a range. As with deleting a row or
column, the cells adjacent to the deleted range either move up or left to fi ll in the space
left by the deleted cells. The Delete Cells command lets you specify whether you want to
shift the adjacent cells left or up, or whether to delete the entire column or row.
Inserting or Deleting a Range
• Select a range that matches the range you want to insert or delete.
• In the Cells group on the Home tab, click the Insert button or the Delete button.
or
• Select the range that matches the range you want to insert or delete.
• In the Cells group on the Home tab, click the Insert button arrow and then click Insert
Cells, or click the Delete button arrow and then click Delete Cells (or right-click the
selected range, and then click Insert or Delete on the shortcut menu).
• Click the option button for the direction to shift the cells, columns, or rows.
• Click the OK button.
You will insert a blank range of cells between the worksheet titles and the table of
customer orders.
To insert the cell range:
1. Select the range A4:G4 . You want to insert blank cells in this range.
2. In the Cells group on the Home tab, click the Insert button arrow , and then click
Insert Cells . The Insert dialog box opens.
3. Verify that the Shift cells down option button is selected.
4. Click the OK button. The existing cells shift down and the new cells are inserted
into the range A4:G4.
Search JabSto ::




Custom Search