Merge and Center, and auto column width

[Bruce Roberson]

It looks like merge and center is the Excel equivalent of
centering across multiple columns that I did in QPW.

The pain about that is I can't figure out how to do more
than a row at a time with this method.

What if I have three or four rows and want them all
centered between say 8 columns, is there a better way to
do this?

The next thing is on my converted spreadsheets, many
columns are not wide enough and have to be widened. Is
there a setting you can turn on in Excel that
automatically adjusts the column width to fit what you
enter? I enjoyed such a feature for a long time in QPW.


Thanks,


Bruce

 

[Ken Wright]

Noooooooooooooooooooooooooooooooooooooo - Don't do it - Merged cells are the spawn of the Devil.
Use Format / Cells / Alignment / Horizontal / center across selection instead.

Format / Columns / Autofit Selection

 

[Paul Corrado]

With your rows and columns selected

Format|Cell|Alignment "Center Across Section"

Usually, its best if you don't merge cells as that often leads to a
reduction in some worksheet functionality.

HTH

PC

 

[Bruce Roberson]

Thanks very much. Now I just hope you read some of the
other posts I have today. I am having a nightmare of a
time with some of these other issues in these other posts.

Thanks again,


Bruce

-----Original Message-----
Noooooooooooooooooooooooooooooooooooooo - Don't do it -

Merged cells are the spawn of the Devil.