Adjust row height to fit text in Excel?
Solved
TOT127
Posted messages
1045
Status
Membre
-
Mst -
Mst -
Hello,
I have an Excel document with 478 cells going down and 15 going across (I’m not explaining myself well...)
Anyway, in the cells, there is text corresponding to dates, abbreviations, etc. And sometimes there’s a lot of text
my problem: the height of the cells "cuts off" the text and I would like to be able to adjust them all at once, without having to do the 478 manually...
Could someone help me?
Thanks
T.
Configuration: Windows 7 / Firefox 11.0
I have an Excel document with 478 cells going down and 15 going across (I’m not explaining myself well...)
Anyway, in the cells, there is text corresponding to dates, abbreviations, etc. And sometimes there’s a lot of text
my problem: the height of the cells "cuts off" the text and I would like to be able to adjust them all at once, without having to do the 478 manually...
Could someone help me?
Thanks
T.
Configuration: Windows 7 / Firefox 11.0
2 réponses
Hello TOT127.
You select all your rows, position yourself at the boundary between two row numbers; the cursor (black arrow pointing right) should turn into a double vertical arrow crossed with a horizontal line: you then double click; all the rows will adjust their height to the size of the largest font contained in that line (and not to the number of characters in the cells).
--
Retirement is great! Especially in the Caribbean ... :-)
☻ Raymond ♂
You select all your rows, position yourself at the boundary between two row numbers; the cursor (black arrow pointing right) should turn into a double vertical arrow crossed with a horizontal line: you then double click; all the rows will adjust their height to the size of the largest font contained in that line (and not to the number of characters in the cells).
--
Retirement is great! Especially in the Caribbean ... :-)
☻ Raymond ♂
it's actually "with 478 rows and 15 columns"
thank you for your response
it works but it doesn't resize all the cells, just one by one despite CTRL+A