can you automatically size text to fill a column?

C

cara

Hi
I have data strings of varying length that I want to have as big as possible
given a fixed column width. Is there a way to automate this or do I have to
format the font for every individual one?
Thanks!
Cara
 
J

Jim Rech

You can do this automatically. First select the text range and assign it
the largest text size you'll ever need, like 24. Then, with the same range
selected, select the "Shrink to Fit" option under Format, Cells, Alignment.
You may have to adjust row heights after this.

--
Jim
| Hi
| I have data strings of varying length that I want to have as big as
possible
| given a fixed column width. Is there a way to automate this or do I have
to
| format the font for every individual one?
| Thanks!
| Cara
 
J

JMay

Jim;
Shrink to Fit seems to only work If your input EXCEEDS the existing Col width.
I think this gal Cara was All Cells to auto-adjust (even the font) to Max
out the
Existing Cell Size.

Or am I missing something here?

Thanks,
Another Jim
 
C

cara

To both Jims - thank you very much. The shrink-to-fit does work for my
purposes and is WAY easier than manually formatting each one as I have been
doing. All these years and I never knew what that little checkbox was...
Thank you!
Cara
 
J

Jim Rech

Right, which is why I suggested a very large font. Then it was always need
to shrink. Or almost always<g>.

--
Jim
| Jim;
| Shrink to Fit seems to only work If your input EXCEEDS the existing Col
width.
| I think this gal Cara was All Cells to auto-adjust (even the font) to Max
| out the
| Existing Cell Size.
|
| Or am I missing something here?
|
| Thanks,
| Another Jim
|
| "Jim Rech" wrote:
|
| > You can do this automatically. First select the text range and assign
it
| > the largest text size you'll ever need, like 24. Then, with the same
range
| > selected, select the "Shrink to Fit" option under Format, Cells,
Alignment.
| > You may have to adjust row heights after this.
| >
| > --
| > Jim
| > | > | Hi
| > | I have data strings of varying length that I want to have as big as
| > possible
| > | given a fixed column width. Is there a way to automate this or do I
have
| > to
| > | format the font for every individual one?
| > | Thanks!
| > | Cara
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting column width in a table with a macro is not working 0
Format column widths from one table to a separate table on same page 1
How can the font and size of (all) citation numbers be altered? 1
Text in note pane of "normal" display suddenly much larger 1
Excel does not accept text format! 0
How to center adjust text above and image in a two column document. 1
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Change a great number of words in word files, with a macro as short as possible. 5

Top