Deleting Elements

Deleting cells, rows, and columns is every bit as straightforward as adding them to a spreadsheet. We've already discussed removing the contents of a cell or cells in Chapter 2.

In this case, we are looking at actually removing an element from a spreadsheet such as a cell, column, row, or sheet. Be advised that when you actually pull one of these elements out of a sheet (particular cells, columns, or rows) rather than just deleting the contents of the cell or cells involved, the other contents of the spreadsheet will be moved to fill in the “gap” left by the removed item(s). Let's take a look at removing each of these spreadsheet elements.

To Remove Cells

The most straightforward way to remove a cell or cells is to select the ...

Get StarOffice™ 5.2 Calc Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.