Inserting, Moving, and Deleting Columns and Rows

After you’ve created a worksheet and begun filling in your data, you might decide to insert a row or column to add data you didn’t think to include when you started. For example, a customer might want to add a product to an order. To accommodate this new data, you can insert a blank row below the last row in their existing order and add the new item there. You can do the same with columns; you can even use the Insert Options button to format the new rows or columns.

On the other hand, there might be times when you no longer need to use a particular row or column. Whether you placed an extra column to add some white space between the main body of data and a summary calculation or a row holds the ...

Get Microsoft® Office Excel® 2007 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.