You have a few options.

1. combine the two events into one............difficult.

2. train users to manually fit the row heights in the merged areas.

3. use center across selection and shade the input cell so's users know
which cell to enter the text.

i.e. shade C1.

Select A1:E1 and "center across"

Text is entered in C1.


Gord


On Tue, 7 Jul 2009 12:46:01 -0700, Anders
wrote:

To Don - duh - i'm sitting in the corner with a tall pointy hat on. :) I got
it.

To Gord - I tried dumping my merged cells, but ran into an issue. My
problem is that this sheet is for others to input information on. When I use
"center across selection" I run into the following:

1. it's not clear what cell the individual should click on to add text/data
- if they click on the wrong one - then the center across selection (CAS)
applies to a smaller selection. E.G. If i have columns a-d formatted as CAS,
and the individual clicked in C and typed, then the centering only takes
place between rows C and D. If I put in a filler spot for [enter text here] -
it centers across the selection. If they click that those words, they are
entering NOT in the correct cell. See my problem?

I'm all for not having merged cells - i get that, but I can't spend all day
formatting and copy/pasting for people who didn't find the right cell to
input in. I will have to distribute a copy of this sheet to 20+ users for
them to fill in and save to a share drive, which I then have to collate into
one report (which is where the formatting exercise would take place)
Granted, this is a twice a month thing, anyway I can reduce wasted time I'm
in for.

What's the better solution? I'm game for anything.
TIA