Inserting, Moving, and Deleting Cells

There’s very little that’s more frustrating than creating a large worksheet and discovering that you forgot to enter data in a few cells. If you’re new to Excel, you might be tempted to cut the existing cells and paste them a few cells below their current location to make room for the new data. But that’s too much like work; there’s an easier way to insert a few cells to give you the room you need. Similarly, it’s not that difficult to move a group of cells to a new location in your worksheet or to delete a group of cells that contains data you entered by accident. After you insert or delete cells, you can choose how to move existing cells to fill in the space left by the deleted cells or to make ...

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.