Home |
Search |
Today's Posts |
#1
|
|||
|
|||
autofit does not autofit
I have a 2000 spreadsheet with merged cells in the column that I am entering
text. I cut and paste text from another document into the cell and the rows do not autofit. I have the cell formatting to wrap text and there is no row height set. When I manually autofit the row, only one line of text will show. Here is an example of text that I am pasting: To Better Serve You DM Quantity 1500, 2500, 5M Flat size 8.5" x 12" Folded 8.5" x 4 4/4 Tri-fold Stock Cougar White Card Stock 8 pt or 10 Special Instructions: double perf on a 4" x 6" postcard |
#2
|
|||
|
|||
autofit does not autofit
Merged cells don't play nice with autofitting rowheights.
Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like: http://groups.google.com/groups?thre...%40tkmsftngp05 If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm rreneerob wrote: I have a 2000 spreadsheet with merged cells in the column that I am entering text. I cut and paste text from another document into the cell and the rows do not autofit. I have the cell formatting to wrap text and there is no row height set. When I manually autofit the row, only one line of text will show. Here is an example of text that I am pasting: To Better Serve You DM Quantity 1500, 2500, 5M Flat size 8.5" x 12" Folded 8.5" x 4 4/4 Tri-fold Stock Cougar White Card Stock 8 pt or 10 Special Instructions: double perf on a 4" x 6" postcard -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can adjust Format Rows Autofit to ensure WYSIWYG when printing | Excel Worksheet Functions | |||
Can one adjust Format Row Autofit to ensure WYSIWYG when printing | Excel Discussion (Misc queries) | |||
Autofit makes rows too tall | Excel Discussion (Misc queries) | |||
Autofit makes rows too tall | Excel Discussion (Misc queries) | |||
Row Autofit Problem | Excel Discussion (Misc queries) |