Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet with some text cells that have been formatted to word
wrap. I also set all cells to autofit the height based on the amount of text. One line autofits, but the lines below it do not. Any ideas about how I can get all the lines to be the correct heigh based on the number of "word wrap" lines there are? Thanks |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Catherine,
Assuming that all the cells have Wrap Text applied. For example suppose that the row of cells the text is in is row 1, then put your cursor between the row numbers 1 and 2 and when you see a black line with a vertical two headed arrow double-click it. This will best fit the row. Important Point: If any of the cells that have Wrap Text also have Merge & Center on then Excel will not best fit the row. In other words - Excel ignores merged cells when performing best fit. -- Cheers, Shane Devenshire "Catherine" wrote: I have a spreadsheet with some text cells that have been formatted to word wrap. I also set all cells to autofit the height based on the amount of text. One line autofits, but the lines below it do not. Any ideas about how I can get all the lines to be the correct heigh based on the number of "word wrap" lines there are? Thanks |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Shane,
Thanks for your reply. I should have been more explicit when I described the problem. Yes, I have word wrap selected. And I tried the double-headed arrow on all the lines that are not auto-fitting, as well as selecting the box in the upper left corner (that selects the entire page), and then double-clicking the double-headed arrow between two lines. So all the things you are mentioning (unless I'm doing something wrong) I've already tried and are not working. Any other ideas? I've run across this before and the only work-around I've found is to manually adjust the line height. Oh, the other thing: The number of characters in each cell is around 80. Thanks! Catherine "ShaneDevenshire" wrote: Hi Catherine, Assuming that all the cells have Wrap Text applied. For example suppose that the row of cells the text is in is row 1, then put your cursor between the row numbers 1 and 2 and when you see a black line with a vertical two headed arrow double-click it. This will best fit the row. Important Point: If any of the cells that have Wrap Text also have Merge & Center on then Excel will not best fit the row. In other words - Excel ignores merged cells when performing best fit. -- Cheers, Shane Devenshire "Catherine" wrote: I have a spreadsheet with some text cells that have been formatted to word wrap. I also set all cells to autofit the height based on the amount of text. One line autofits, but the lines below it do not. Any ideas about how I can get all the lines to be the correct heigh based on the number of "word wrap" lines there are? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Autofit text into a cell | Excel Discussion (Misc queries) | |||
autofit text that is pulling data from another tab | Excel Worksheet Functions | |||
Possible to automatically autofit row height to text in Excel? | Excel Discussion (Misc queries) | |||
Wrap text and row autofit not working in Excel | Excel Discussion (Misc queries) | |||
if amount <0, put the all line in red | Excel Worksheet Functions |