Inserting Areas

[ LiB ]

Occasionally you need to insert a column, row, or a single cell in the middle of existing information. Inserting rows, columns, or cells moves data to make room for new rows or columns .

Inserting Columns

You can insert a column anywhere you need it. Excel moves the existing columns to the right to make room for the new column.

NOTE

To insert multiple columns, select headings across multiple columns.

Inserting Rows

You can insert a row anywhere you need it. Excel will move the existing rows down to make room for the new ones.

NOTE

To insert multiple rows, select cells across multiple rows.

Inserting Cells

Instead of inserting an entire column or an entire row, you can insert a single cell or even a group of cells. Excel then moves existing data down or to the right, depending on the option you specify.

[ LiB ]