Adding and Deleting Columns and Rows

It might take a little time to get your worksheet laid out perfectly, but getting it exactly right is simple enough and very satisfying. You’ll probably need to rearrange some columns or rows, delete empty or useless columns or rows, or add new ones. You might need to make room for some data that you want to move. If you find that you need an existing row or column but that its current content is useless, you can simply delete the content but leave the empty row or column intact.

Add a Column

  1. Right-click the column header at the right of where you want the new column.

  2. Choose Insert from the shortcut menu.

Tip

Get 2007 Microsoft® Office System Plain & Simple 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.