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

Chapter 4. Editing Cell Content > Deleting Cells, Columns, and Rows

Deleting Cells, Columns, and Rows

Unlike deleting a single cell's content to leave a cell blank or to replace it with new content, deleting groups of cells entirely is normally done to tighten up a worksheet or remove outdated content. While you can't really delete a cell, column, or row (there are a fixed number in every worksheet), you can delete the content in a cell, row, or column, and have the surrounding cells move into the deleted cells' place. You can also remove sheets from workbooks and delete whole workbook files from disk. When you delete cell content, however, there can be unpleasant results. See the Troubleshooting section at the end of this chapter for information on potential pitfalls.

With cell(s) selected, choose Edit, Delete to remove the selected cells from the worksheet. This command will result in a question, appearing in the form of a dialog box as shown in Figure 4.12.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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