Sizing Rows

[Gretchen'sTreats]

Good afternoon;

I have a decent knowledge of Excel, but this problem eludes me.

I have built an estimating template that uses bulleted lines [alt | enter to generate a linespace] to describe each item we are bidding (this is the company standard and cannot be eliminated).

I have to manually adjust the size of the row for each line item, and it is getting very old.

Doubleclick on the line at the base of the row collapses it to a single line.
Alt | Doubleclick does the same thing.
Control | Doubleclick does the same thing.
Control+ Alt | Double click does the same thing.
Control + Shift | Double click does the same thing.

I can't really write a macro to size it to any given row size because the next time I use that row it will surely be larger or smaller.

Is there a shortcut to do this simple act or am I consigned to this circle of purgatory for the duration of my employment here?

 

[Smitty]

Welcome to the Board!

Have you tried Select All-->Home-->Cells-->Format-->AutoFit Row Height?

If that works for you, then you can record a macro repeating it and call it whenever you need it.

HTH,

 

[Gretchen'sTreats]

No, I haven't.

I did, it did what I thought it would do: resize all of the rows to the same size.

Thankfully there's an undo button.

 

[Smitty]

It should size each row to it's own maximum size, they shouldn't all be the same. Are you entering empty line continuations?

 

[shg]

Is the text in merged cells?

 

[Gretchen'sTreats]

Not sure what you mean by empty line continuations.

I have quite a few long phrases entered in small cells that are a list used for drop down selections.

I also have linespaces with bullets and nothing after them to facilitate the whole thing.

But it resized everything...include lines that didn't have those conditions present.

 

[Gretchen'sTreats]

Yes, the text is in merged cells.

 

[Smitty]

Yes, the text is in merged cells.

Then your company standard format notwithstanding, I'd imagine that's where a good bit of your problem lies. Merged Cells are evil.

 

[shg]

Excel won't autofit the row height of merged cells. Time for a new standard.