| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
resizing row height automatically?
I have information coming into cells from 5 different sheets. My row height
varies from row to row. Its constantly being updated so I would like it to resize the row automatically. How can I accomplish this? |
|
#2
|
|||
|
|||
|
Just curious, "how" is it coming in (i.e., from what other application or
file type)? |
|
#3
|
|||
|
|||
|
No different file types. Just seperate sheets for each day. Formula looks like:
='Monday'!B9&CHAR(10)&'Tuesday'!B9&CHAR(10)&'Wedne sday'!B9&CHAR(10)&'Thursday'!B9&CHAR(10)&'Friday'! B9 But not every row will have 5 lines of text all the time, so I was trying to find a way to make it resize the height automatically. "DNA" wrote: Just curious, "how" is it coming in (i.e., from what other application or file type)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Paste without changing row height | Excel Discussion (Misc queries) | |||
| autofit height of row - ajit | Excel Discussion (Misc queries) | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| How do I change row height to 16.0? I get choice of 15.6 (26 Pix. | Excel Discussion (Misc queries) | |||
| How do I make Excel automatically adjust a row's height once I in. | Excel Worksheet Functions | |||
Linear Mode
