Merge and Center and Center Accross Selection

  • Thread starter Thread starter Bojingles03
  • Start date Start date
B

Bojingles03

What is the difference between Merge/Center and Center across selection? As
far as i can tell they are the same thing.
 
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.
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Happy Birthday Muckshifter 6
Best solution to merge multiple Outlook contacts easily 2
Excel Cell Merge 5
Center across selection 2
Intel NUC Poor WiFi - External Antenna Mod 7
Neuralink 5
Windows 10 How to remove Action Center following anniversary update 6
This gave us a chuckle! 1

Back
Top