| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Set Rows with Merged Cells so They Adjust Automatically
I am working in a rather large workbook (9 tabs) which includes 3 tabs with
several merged columns of data. I have activated the Word Wrap feature but I need the rows with the merged cells to adjust height automatically. I have tried using the code in other posts but must be doing something wrong as I cannot get this function to work. I am currently using the workbook in the 2003 version of Excel but will need to drop it back into 2000 when it is complete. Any suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Set Rows with Merged Cells so They Adjust Automatically
Excel does not auto-adjust the row height of merged cells..
There's a couple of suggestions he http://exceltips.vitalnews.com/Pages... ext_Wrap.html -- Hope that helps. Vergel Adriano "MGC" wrote: I am working in a rather large workbook (9 tabs) which includes 3 tabs with several merged columns of data. I have activated the Word Wrap feature but I need the rows with the merged cells to adjust height automatically. I have tried using the code in other posts but must be doing something wrong as I cannot get this function to work. I am currently using the workbook in the 2003 version of Excel but will need to drop it back into 2000 when it is complete. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically color merged cells | Excel Discussion (Misc queries) | |||
| Automatically re-sizing merged cells | Excel Worksheet Functions | |||
| Automatically adjust cells to fit text | Excel Discussion (Misc queries) | |||
| Adjust the size of cells automatically | Excel Discussion (Misc queries) | |||
| automatically fit an image into merged cells | Excel Discussion (Misc queries) | |||
Linear Mode
