• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 1. Getting the Most Out of Ranges > Inserting a Cell or Range

Inserting a Cell or Range

In some worksheets, you might need to insert only a single cell or a range of cells, so as not to disturb the arrangement of surrounding data. For example, suppose that you want to add a Repair line between Rent and Supplies in the Quarterly Expenses table in Figure 1.16. You don't want to add an entire row because it would create a gap in the Quarterly Sales table. Instead, you can insert a range that covers just the area you need. Follow these steps to see how this works:

Select the range where you want the new range to appear. In the Quarterly Expenses example, you would select the range A8:D8 (see Figure 1.18).

Figure 1.18. When inserting a range, first select only the range that you want moved to accommodate the new cells. In this example, only the appropriate cells in the Quarterly Expenses table have been selected.

Choose Insert, Cells. Excel displays the Insert dialog box, shown in Figure 1.19.

Figure 1.19. Use the Insert dialog box to tell Excel which way to shift the existing cells.

Click either Shift Cells Right or Shift Cells Down, as appropriate.

Click OK. Excel inserts the range.

(Optional) Use the Insert Options control (shown in Figure 1.20) to click the formatting option you want to apply to the inserted cells.

Figure 1.20. Excel has shifted the existing cells down to create room for the new range.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint