O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required