Microsoft Office Tutorials and References
In Depth Information
Change the Column Width
5
chapter
Formatting Excel Ranges
The Column Width dialog box
appears.
5 In the Column width text box,
type the width you want to use.
6 Click OK.
A Excel adjusts the column width.
B You can also move over the
right edge of the column
heading ( changes to ) and
then click and drag the edge to
set the width.
Is there an easier way to adjust the
column width to fit the contents of a
column?
Yes. Click any cell in the column, click
Home , click Format , and then click
AutoFit Column Width . Alternatively,
move over the right edge of the
column heading (
Is there a way to change all the column widths at
once?
Yes. Click to select the entire worksheet, and
then follow the steps in this section to set the
width you prefer. If you have already adjusted some
column widths and you want to change all the other
widths, click Home , click Format , and then click
Default Width to open the Standard Width dialog
box. Type the new standard column width, and then
click OK.
changes to
)
and then double-click.
Search JabSto ::




Custom Search