Microsoft Office Tutorials and References

In Depth Information

**Adding To Sheets—Inserting Rows, Columns and Cells**

Adding To
Sheets—Inserting Rows, Columns and Cells

Having the capability to add rows, columns, and cells raises the obvious question: if you have all those

billions of cells to begin with, why would you need to supplement them with even more? The answer—or

at least the standard answer—is that after you’ve constructed a table, for instance, you may decide you

need an extra field’s worth of data—and that decision means you’ll have to introduce a new column into

the table. And if you want that column to appear
between
two columns already in place, you’ll need to

insert another one. If, on the other hand, you’ve entered data all over the worksheet and you’d like to see

them a bit closer to one another, you may want to delete a column or two.

The means for adding and deleting columns or rows are pretty easy (although as usual, there’s

more than one way. We’re demonstrating the most straightforward approach here). But before we

demonstrate how it’s done, we need to anticipate and answer a big question—namely, what happens

to cell references when additions or deletions are carried out?

For example, suppose you’ve written this formula in cell H3:

=AVERAGE(B17:B32)

If you delete any of columns between C and H, will the cells referred to in that expression change?

After all, delete one such column and the formula now appears in cell G3–and as a result, will the

formula read

=AVERAGE(A17:A32) ?

The answer is no. When you add or delete rows or columns, Excel
maintains
the existing cell

references that might otherwise be impacted by the additions or deletions, so not to worry.
But
keep in

mind that if you insert a row or column such that cells
contributing
to a formula are repositioned, the

formula
will
rewrite itself correspondingly. If a column is added to the left of the B column in the first

example above, the formula will now read

=AVERAGE(C17:C32)

Because the values being added are now in column C.

Inserting a Column

To go ahead and insert a column, just click anywhere in the column to the
right
of where you want the

new one to be inserted. Thus if you want to insert a column between H and I, click any cell in I. Then

cl i ck Home
Cells
button group
Insert
Insert Sheet Columns
(Figure7–1):

Figure 7–1.
Where to insert a column or a row