Auto size cells
I'm inserting short paragraphs into cells (copied from a text editor -- so no URLs, no special characters). The cells are set to word wrap, and I've tried changing the vertical alignment, but that has had no effect.
The problem: some of the cells resize automatically and display the text. Others in the same column do not.
I know I can resize the rows, but that seems kind of clunky. Is there a secret setting that will automatically increase the row height as necessary?
I've tried Brad's solution from http://www.vbaexpress.com/kb/getarticle.php?kb_id=421 but while it did set the text to a specific WIDTH, it didn't change the row height.
The problem: some of the cells resize automatically and display the text. Others in the same column do not.
I know I can resize the rows, but that seems kind of clunky. Is there a secret setting that will automatically increase the row height as necessary?
I've tried Brad's solution from http://www.vbaexpress.com/kb/getarticle.php?kb_id=421 but while it did set the text to a specific WIDTH, it didn't change the row height.
ASKER
I should have said... this is Office 2000... so I don't know where I'd find the "height separator"... Even "auto-fit"ting the row height doesn't have an effect.
Wow it has been some time since i last saw Office 2000, isnt there a line between rows 1 and 2 like the images?
ASKER
Maybe this will help.
truncated-cells.jpg
truncated-cells.jpg
Yes that helps...
So first click where the blue arrows points to to select the whole sheet.
Next double click any line between two rows. In my example i point to the line between rows 158 and 159. Double clicking this line while all selected it should 'autoheight' for all rows.
So first click where the blue arrows points to to select the whole sheet.
Next double click any line between two rows. In my example i point to the line between rows 158 and 159. Double clicking this line while all selected it should 'autoheight' for all rows.
ASKER
*grumbling*
After step 1, when I get directly on the line separating the two rows, I get the icon similar to the one you get when you widen a column (except the arrows point up and down rather than to both sides). Double-clicking does nothing; dragging the line down makes all of the cells taller (as expected), but doesn't resolve the truncating issue -- even if I increase the row to more than enough vertical room.
If I'm slightly off the line, I see a white plus sign, and even clicking once selects whatever row it is.
After step 1, when I get directly on the line separating the two rows, I get the icon similar to the one you get when you widen a column (except the arrows point up and down rather than to both sides). Double-clicking does nothing; dragging the line down makes all of the cells taller (as expected), but doesn't resolve the truncating issue -- even if I increase the row to more than enough vertical room.
If I'm slightly off the line, I see a white plus sign, and even clicking once selects whatever row it is.
Hi
The icon you see is what i would expect, maybe the double clicking is not present in 2000.
After step 1, if you click 'format' -> Row autofit, does this help?
The icon you see is what i would expect, maybe the double clicking is not present in 2000.
After step 1, if you click 'format' -> Row autofit, does this help?
ASKER
No effect at all.
I did find that, when entering the text into a cell, if I select the cell below the one I'm entering data into AND the lower cell is empty, then it resizes.
I did find that, when entering the text into a cell, if I select the cell below the one I'm entering data into AND the lower cell is empty, then it resizes.
This is one of those problems where it would be desirable to see the actual workbook.
FWIW, merged cells prevent the AutoFit from working. In looking at your screenshot, I see four columns of data, starting with column A and continuing through column G. Either you have hidden some columns, or you have merged some cells.
Also, the row height cannot exceed 409.5 points, and Excel 2000 doesn't promise to display more than about 1200 characters as I recall.
FWIW, merged cells prevent the AutoFit from working. In looking at your screenshot, I see four columns of data, starting with column A and continuing through column G. Either you have hidden some columns, or you have merged some cells.
Also, the row height cannot exceed 409.5 points, and Excel 2000 doesn't promise to display more than about 1200 characters as I recall.
ASKER
I've not merged any cells, and in the screen shot, several columns were hidden.
I don't think many of the cells that display XXXXX....XXXX have 1200 characters, and I can't see anything in any of them that should result in the word-wrap not working.
But... ask and ye shall receive...
28403560.xls
I don't think many of the cells that display XXXXX....XXXX have 1200 characters, and I can't see anything in any of them that should result in the word-wrap not working.
But... ask and ye shall receive...
28403560.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you want to test whether any of the cells contain too many characters, put the following formula in cell G1:
=LEN(F1)
Then doubleclick the little square at bottom right of the selection marquee surrounding cell G1. That will copy the formula down to the first blank cell in column F.
=LEN(F1)
Then doubleclick the little square at bottom right of the selection marquee surrounding cell G1. That will copy the formula down to the first blank cell in column F.
ASKER
*laughing hysterically*
The longest description -- by a significant margin -- is from some guy who managed to come up with 1199 characters on Microsoft Excel...
The longest description -- by a significant margin -- is from some guy who managed to come up with 1199 characters on Microsoft Excel...
ASKER
Amazing. Simply amazing.
Thank you, Brad!
Thank you, Brad!
Why not select the whole spreadsheet and double click the height separator and all rows are set to Heights that are fitting.