Microsoft Office Tutorials and References
In Depth Information
Adjusting Columns and Rows
Inserting One or More Rows
Adding rows is similarly easy. It’s all a matter of
selecting the row below the spot where you need
a new one—or, if you need two or more new rows,
selecting as many existing rows as you need
below the point where the new ones should
appear. Once the selection is made, pick your
Right-click. Right-click the row number
of the row below where you need the
new row. Choose Insert from the pop-up
menu, as shown in Figure 5-10, and in a
nanosecond, you have a new row. If you
need more than one row, select as many
rows as you need, using rows beneath the
point where the new ones should appear,
and use the right-click method. However
many rows are selected when you issue
the command, that’s how many new rows
you get.
Figure 5-9
The inserted column appears to the right
of the column originally selected.
Use the Insert button. Select the columns
to the right of where you want your new
ones to appear, and use the Insert button
on the Home tab. You don’t need to click
the arrow to display the menu—just
click the Insert button itself, and your
new columns appear (see Figure 5-9).
If you do click the arrow, just choose
Insert Sheet Columns from the menu.
If you’ve used the Merge & Center button
to merge, say, a series of cells across the
top of a series of columns (to house a title
for the data), adding columns within that
range of columns will expand the merged
cell. If this will create an undesirable
change for your merged cell, unmerge it
(click in the cell and then use the Unmerge
Cells command in the Merge & Center
drop-down menu) before inserting the
columns, and then click Merge & Center to
merge and center the desired range of cells.
Figure 5-10
Select as many rows as you want to add, and
right-click them to access the Insert command.
Search JabSto ::

Custom Search