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

Chapter 12. Making It Look Good > 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 choice on the Insert or Delete dialog box.

To insert or delete cells:

1.
Click the cell below or to the right of where you want to add the new, blank cell (Figure 12.9).

Figure 12.9. Click a cell to delete, or click the cell to the right of or below where you want a new one inserted.


or

Click the cell you want to delete.

2.
To insert a cell, choose Insert > Cells (Figure 12.10), or click the mouse button while holding down , and choose Insert from the shortcut menu. The Insert dialog box appears.

Figure 12.10. To insert a cell, choose Insert > Cells.


or

To delete a cell, choose Edit > Delete (Figure 12.11), or click the mouse button while holding down , and choose Delete from the shortcut menu. The Delete dialog box appears.

Figure 12.11. To delete a cell, choose Edit > Delete.


3.
In the Insert dialog box, select either Shift cells right or Shift cells down (Figure 12.12).

Figure 12.12. Choose Insert options.


or

In the Delete dialog box, select either Shift cells left or Shift cells up (Figure 12.13). The cells are shifted as specified (Figure 12.14).

Figure 12.13. Choose Delete options.


Figure 12.14. The inserted cell appears.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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