Inserting and Deleting

In the realm of spreadsheets, the complementary actions of inserting and deleting are collectively the second most used editing techniques. Inserting and deleting rows and columns of information have some nuances that don’t exist in the world of word processing, for example, but that you must consider.

Inserting Columns and Rows

Inserting Columns and Rows

On the Home tab, you can click commands on the Insert menu in the Cells group to add cells, columns, and rows to a worksheet. However, when you need to insert entire rows or columns, it’s easiest to right-click the column or row heading, which simultaneously selects the row or column and displays the ...

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