Microsoft® Excel® 2010 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. 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

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—and even add a new sheet to a workbook. However, when you need to insert entire rows or columns, it’s easiest to right-click a column or row heading, which simultaneously selects ...