In Excel 2003 (haven't tested this in 2007):

1. Create a new worksheet
2. Type some text in cell A1
3. Select A1 and B1
4. Right click, format cells, Alignment tab, set the alignment to "Center
Across Selection"
5. Now select cells C1 and D1 -- make sure A1 and B1 are no longer selected
and no text has been typed into C1 or D1.
6. Right click, format cells, Alignment tab, set the alignment to "Center
Across Selection"

The text in A1 is centered over the range A1:D1.

Is this a bug?

On Dec 12, 7:08 am, "Doug" <dougATloweNOSPAMwriterDOTyou-know-what
wrote:
In Excel 2003 (haven't tested this in 2007):

1. Create a new worksheet
2. Type some text in cell A1
3. Select A1 and B1
4. Right click, format cells, Alignment tab, set the alignment to "Center
Across Selection"
5. Now select cells C1 and D1 -- make sure A1 and B1 are no longer selected
and no text has been typed into C1 or D1.
6. Right click, format cells, Alignment tab, set the alignment to "Center
Across Selection"

The text in A1 is centered over the range A1:D1.

Is this a bug?

Seems more like a feature than a bug.
You can't center nothing across a selection so it looks like excel is
guessing that the user is really wanting to center the adjacent text
across a wider range.

Ken Johnson

Excel centers across from the first cell with center across format to the
last contiguous empty cell with that format. When or in what order you
assigned the center across format to any given cell in that range doesn't
matter. A cell either has the format or it doesn't.

--
Jim
"Doug" <dougATloweNOSPAMwriterDOTyou-know-what wrote in message
. ..
| In Excel 2003 (haven't tested this in 2007):
|
| 1. Create a new worksheet
| 2. Type some text in cell A1
| 3. Select A1 and B1
| 4. Right click, format cells, Alignment tab, set the alignment to "Center
| Across Selection"
| 5. Now select cells C1 and D1 -- make sure A1 and B1 are no longer
selected
| and no text has been typed into C1 or D1.
| 6. Right click, format cells, Alignment tab, set the alignment to "Center
| Across Selection"
|
| The text in A1 is centered over the range A1:D1.
|
| Is this a bug?
|
|