Microsoft® Office Excel 2003 Inside Out

Inserting and Deleting

In the realm of spreadsheets, the complementary actions of inserting and deleting are collectively the second most-used editing techniques. There are nuances to inserting and deleting rows and columns of information that don't exist, for example, in the world of wordprocessing, but that must be taken into consideration.

Inserting Columns and Rows

You can choose options on the Insert menu to add cells, columns, and rows to a worksheet. However, when you insert, it's easiest to right-click the column or row heading, which simultaneously selects the row or column and displays the shortcut menu shown in Figure 7-9. (You can also drag through several rows or columns, and then right-click the selection.) Then just choose Insert ...