Microsoft Office Tutorials and References
In Depth Information
Adding and Moving
Columns or Rows
Inserting rows is just as easy as inserting new columns. Just follow these steps:
1. Findtherowthat’simmediately below whereyouwanttoplacethenewrow.
That means that if you want to insert a new, blank row between rows 6 and 7,
start by looking at the existing row 7.
2. Right-clickontherowheader(thenumberedboxatthefar leftoftherow)
Excel inserts a new row, and all the rows beneath it are automatically moved
down one row.
Note: In the unlikely event that you have data at the extreme right edge of the spreadsheet, in column
XFD, Excel doesn’t let you insert a new column anywhere in the spreadsheet because the data would be
pushed off into the region Beyond The Spreadsheet’s Edges. Similarly, if you have data in the very last row
(row 1,048,576), Excel doesn’t let you insert more rows. If you do have data in either of these spots and
try to insert a new column or row, Excel displays a warning message.
Inserting Copied or Cut Cells
Usually, inserting entirely new rows and columns is the most straightforward way to
change the structure of your spreadsheet. You can then cut and paste new
information into the blank rows or columns. However, in some cases, you may simply want
to insert cells into an existing row or column.
To do so, begin by copying or cutting a cell or group of cells and then select the spot
you want to paste into. Next, choose Home ➝ Cells ➝ Insert ➝ Insert Copied Cells
from the menu (or Home ➝ Cells ➝ Insert ➝ Insert Cut Cells if you’re performing a
cut instead of a copy operation). Unlike the cut-and-paste feature, when you insert
cells, you won’t overwrite the existing data. Instead, Excel asks you whether the
existing cells should be shifted down or to the right to make way for the new cells (as
shown in Figure 15-11).
When you insert copied cells, Excel asks whether it should move the existing cells down
or to the right.