Microsoft Office Tutorials and References
In Depth Information
Adjusting Columns and Rows
Inserting One or More Columns
Luckily, as easy as it is to forget a row or column
when you’re building your worksheet, it’s that
easy to remedy the situation by adding one
or more rows and/or columns whenever and
wherever you want.
To add a column, choose one of these methods:
Right-click. Right-click the letter of the
column to the right of where you need
an additional column. Choose Insert from
the pop-up menu, as shown in Figure 5-8,
and voila! A new column appears. If you
need more than one column, select as
many as you need, using columns to the
right of the spot where the new ones
should appear, and use this right-click
method. However many columns are
selected when you issue the command,
that’s how many new ones you get.
Use the Format button menu to choose
how to adjust your row height.
Enter a value to make the row taller or shorter.
Inserting and Deleting
Columns and Rows
The most common things people forget when
planning and setting up a worksheet is a column
or row for some of the data they’ll need to enter.
When setting up a list database, for example, it’s
quite common to forget one of the fields, and
therefore need to add a column. Same thing
with rows—if you imagine setting up a budget
worksheet, it’s easy to also imagine forgetting
one of the expenses and needing to go back and
insert a row where that item would appear in
the list, so the data can be entered.
Right-click a column letter and choose
Insert to add a new column.