Merged Cells

harrywd

New Member
Joined
Jun 21, 2004
Messages
45
How do I sort a colume in a spread sheet that, I guess, contains merged cells? I didn't create the spread sheet and have never worked with merged cells.
From the looks of the spred sheet it appears that the last few cells of each row have been merged under that row.

The message I get when I try and sort on colume 'm' is: "The operation requires the merged cells to be identically sized".

THX,
Harry
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,328
Office Version
  1. 365
Platform
  1. Windows
Harry

Can you lose the merged cells?

If that's possible I would seriously recommend it, merged cells are just evil. :devilish:
 

TrippyTom

Well-known Member
Joined
Nov 16, 2004
Messages
587
:devilish: MERGED CELLS ARE THE DEVIL!!! :devilish:

Seriously. MSoft should never have given us the option.
You can create the same effect by going into:
Format > Cells > (ALIGNMENT tab)
under the HORIZONTAL Text Alignment choose: Center Across Selection

This is always your better option.
 

harrywd

New Member
Joined
Jun 21, 2004
Messages
45
I agree....they are evil, but I have a spread sheet that has the last few cells of each row merged under that row and I need to to sort on that data.

I'd be glad to share the spread sheet if I knew how.

THX,
Harry
 

harrywd

New Member
Joined
Jun 21, 2004
Messages
45
Harry

Can you lose the merged cells?

If that's possible I would seriously recommend it, merged cells are just evil. :devilish:

What do I do with the .xla file once it is unzipped?
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,565
Messages
5,765,133
Members
425,263
Latest member
alcat

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top