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

Chapter 12. Structuring the Sheet > Inserting and Deleting Cells

Inserting and Deleting Cells

When you tell Excel to insert or delete a cell within a range of data, Excel needs to know how to move the data that’s in adjacent cells. You specify your preferences in the Insert or Delete dialog box.

To insert a cell:

1.
Click the destination for the new, blank cell (Figure 12.9).

Figure 12.9. Click a cell.


2.
Choose Cells from the Insert menu.

or

Right-click the cell and choose Insert from the shortcut menu.

3.
In the Insert dialog box, select either Shift Cells Right or Shift Cells Down (Figure 12.10).

Figure 12.10. Shift cells right or down in the Insert dialog box.


The new cell appears (Figure 12.11).

Figure 12.11. The inserted cell.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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