Alternative To Merge & Center

**Spencer** · 03-14-2011, 07:02 PM

I don't like it when other people use merge and center in their spreadsheets, but I find myself leaning towards doing it in one of mine. I'm sure most of you are aware of the issues using merge and center can cause, so I won't go into them.

Please take a look at the attached example and let me know if you have any suggestions for a different way to go about clearly identifying the "Subcontractor", "Materials", and "Labor" sections without using Merge and Center as the example shows.

**ConneXionLost** · 03-14-2011, 07:12 PM

A far superior choice would be "Center Across Selection".

1. Select range A1:L1

2. Right click on range, Format Cells.

3. Remove "Merge Cells"

4. Select "Center Across Selection" for Horizontal Alignment.

Cheers,

**Spencer** · 03-14-2011, 08:17 PM

Originally Posted by ConneXionLost

A far superior choice would be "Center Across Selection".

1. Select range A1:L1

2. Right click on range, Format Cells.

3. Remove "Merge Cells"

4. Select "Center Across Selection" for Horizontal Alignment.

Cheers,

Beautiful! I knew there had to be a better solution.

Thanks for the quick and helpful response,
Spence