Excel: adjust text size to cell
syl20-11
Posted messages
37
Status
Membre
-
Patrice33740 Posted messages 8400 Registration date Status Membre Last intervention -
Patrice33740 Posted messages 8400 Registration date Status Membre Last intervention -
Hello,
In Excel 2003, I have a table whose cell sizes I don't want to change.
When I enter long text, I want the text size to decrease in order to fit the cell.
Through the menu cell format --> alignment, I am able to wrap text automatically or adjust the text size, but not both at the same time.
Having long text written in small font on a single line does not help me, as my cells are sized to contain 4 lines of characters.
Is there a trick to achieve what I want?
Thank you for your help.
In Excel 2003, I have a table whose cell sizes I don't want to change.
When I enter long text, I want the text size to decrease in order to fit the cell.
Through the menu cell format --> alignment, I am able to wrap text automatically or adjust the text size, but not both at the same time.
Having long text written in small font on a single line does not help me, as my cells are sized to contain 4 lines of characters.
Is there a trick to achieve what I want?
Thank you for your help.
4 réponses
Okay, thanks for the response, it will save me from looking for nothing,
and I will avoid the macro, because I don't master it at all.
and I will avoid the macro, because I don't master it at all.
The trick is to decrease the font size yourself until the text fits in the cell.
You can also replace the text with a hyperlink that takes you to a text file or a Word document where you can read comfortably, or to another sheet in your Excel file where you have enough space to display your text clearly.
--
Retirement is nice! Especially in the Caribbean ... :-)
☻ Raymond ♂
You can also replace the text with a hyperlink that takes you to a text file or a Word document where you can read comfortably, or to another sheet in your Excel file where you have enough space to display your text clearly.
--
Retirement is nice! Especially in the Caribbean ... :-)
☻ Raymond ♂