I admit that I'm somewhat of an Excel
fan. I use it for shopping lists, travel
packing lists, you name it.
A question I hear often is this: Once
the info is in Excel, how do I format a
particular cell to wrap the text and
center it?
Let's say you're designing an address
directory in Excel.
You want all the addresses to wrap to
another line if they're too long because
otherwise the page would be too wide -
and not visible without sliding over
again and again, and then back for the
next one. What a pain.
Follow these easy steps:
- Highlight the actual cell (or click
to the left of the entire row to format
the whole row, or click the cell between
A and 1 to format the entire document at
once);
- Right-click in the cell and choose
Format Cells...
- Click on the Alignment tab;
- Choose Center and Center again for
the Horizontal and Vertical alignment
options;
- Check the box for Wrap Text;
- Click on OK to accept your options.
In the example above, you would now hover
your cursor on the horizontal line that
separates that row from the next - all the
way on the left edge of your document, until
you see the double-sided arrows pointing
left and right.
Once you see them, double-click. Excel
automatically adjusts the row to make it
deep enough to 'hold' that second row of
information.
This last step can be used to adjust
vertical columns, too.
Many of you regular Excel users will know
this week's tip, but for those of you who
don't, you'll feel like you struck gold the
first time you use it.
Best wishes in using today's Tip of the
Week. Next week's tip will build
upon this one, so stay tuned, and see
you then!
