| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Resizing merged / wrapped cells.
Is it possible to automatically resize a cell to show all the text when it is
merged and wrapped. Home/Cells/Format/Auto Fit Row Height does not work. I am merging and wrapping cells B4 - G4 with 3 rows of text and resizing by dragging the row to increase the size is a poor solution. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Resizing merged / wrapped cells.
If cells are merged. the row will not autofit even with wrap text enabled
without using VBA See google search thread for code by Greg Wilson http://groups.google.com/group/micro...1c160cbeb27874 Second piece of advice is.............get rid of the merged cells. They cause no end of problems with copying, pasting, sorting, filtering, autofitting and a few(many?) others that have slipped my mind at present. Gord Dibben MS Excel MVP On Wed, 24 Oct 2007 09:24:00 -0700, Nathan Elphick wrote: Is it possible to automatically resize a cell to show all the text when it is merged and wrapped. Home/Cells/Format/Auto Fit Row Height does not work. I am merging and wrapping cells B4 - G4 with 3 rows of text and resizing by dragging the row to increase the size is a poor solution. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Resizing merged / wrapped cells.
Gord,
Wonderful - many thanks N. "Gord Dibben" wrote: If cells are merged. the row will not autofit even with wrap text enabled without using VBA See google search thread for code by Greg Wilson http://groups.google.com/group/micro...1c160cbeb27874 Second piece of advice is.............get rid of the merged cells. They cause no end of problems with copying, pasting, sorting, filtering, autofitting and a few(many?) others that have slipped my mind at present. Gord Dibben MS Excel MVP On Wed, 24 Oct 2007 09:24:00 -0700, Nathan Elphick wrote: Is it possible to automatically resize a cell to show all the text when it is merged and wrapped. Home/Cells/Format/Auto Fit Row Height does not work. I am merging and wrapping cells B4 - G4 with 3 rows of text and resizing by dragging the row to increase the size is a poor solution. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data is not visible in merged and wrapped cells | Excel Worksheet Functions | |||
| Excel - Automate row width for merged cells with wrapped text | Setting up and Configuration of Excel | |||
| How do I get all text to print in merged and wrapped cells. | Excel Discussion (Misc queries) | |||
| Excel - merged cells w/wrapped text auto row height doesn't work. | Excel Discussion (Misc queries) | |||
| Auto fit wrapped and merged cells | Excel Discussion (Misc queries) | |||
Linear Mode
