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
 
Search JabSto ::




Custom Search