Merge and Center, and auto column width

  • Thread starter Thread starter Bruce Roberson
  • Start date Start date
B

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
 
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
 
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
 
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.
 
Back
Top