Merge and Center and Center Accross Selection

[Bojingles03]

What is the difference between Merge/Center and Center across selection? As
far as i can tell they are the same thing.

 

[PJ]

With the Merge/Center option you actually merge two or more cells into a
single large cell with your data in the center of it. With Center Across
Selection the selected cells all remain separate with the data merely
displayed in the center.

By the way, most Excel experts recommend avoiding merged cells as far as
possible as they can cause problems with calculations, filtering, sorting etc.

 

[sylvia]

if you merge and center it merges and centers in cells that datas in, if you
merge and center across selection you can select how many cells you want
merged.

 

[Gord Dibben]

Sylvia

There is no such command as Merge and Center Across Selection.

Merge and Center is one command.

Center Across Selection is another.

See help on the difference..............and it is big difference<g>


Gord Dibben MS Excel MVP