Sorting error message

Mar 13th, 2002, 02:03 PM

Question:
When I try to sort a spreadsheet, I got an error message
"This operation requires merged cells to be identically sized"
How could I solve this problem
Please Help
Thanks in advance

Mark W. · Mar 13th, 2002, 02:08 PM

Either remove the Merge cell format from all of the cells in the sort range or merge the cells on each row/column of the sort range in the same fashion.

[ This Message was edited by: Mark W. on 2002-03-13 13:08 ]

Mar 13th, 2002, 02:14 PM

sorry, I am not sure how to remove the merge nor how to merge the cells in the same fashion.
Could you explain a little bit more how to do those two
I am very appreciated

Aladin Akyurek · Mar 13th, 2002, 02:21 PM

Quote:

On 2002-03-13 13:14, Anonymous wrote:
sorry, I am not sure how to remove the merge nor how to merge the cells in the same fashion.
Could you explain a little bit more how to do those two
I am very appreciated

Activate the merged cells.
Activate Format|Cells.
On the Alignment tab, check then uncheck "Merge cells".

[ This Message was edited by: Aladin Akyurek on 2002-03-13 13:22 ]

Mar 14th, 2002, 06:12 AM

I am modifying a big spreadsheet for a company. I think someone merged the cells all over the spreadsheet. Is there a way to remove the merge at once?
Thanks in advance

Audiojoe · Mar 14th, 2002, 06:16 AM

If you highlight the entire sheet, then do the same thing that Aladin sugested, that will work. The merge cells checkbox will be a dullened grey, but you can still uncheck it

Mar 14th, 2002, 06:17 AM

When I go to Format->cell->remove merge check box
I got a "Too Many Different Cell Formats" error message
What should I do now? Please Help
Thanks in advance

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 02:03 PM	#1
Guest Posts: n/a	Question: When I try to sort a spreadsheet, I got an error message "This operation requires merged cells to be identically sized" How could I solve this problem Please Help Thanks in advance

Mar 13th, 2002, 02:08 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Either remove the Merge cell format from all of the cells in the sort range or merge the cells on each row/column of the sort range in the same fashion. [ This Message was edited by: Mark W. on 2002-03-13 13:08 ]

Mar 13th, 2002, 02:14 PM	#3
Guest Posts: n/a	sorry, I am not sure how to remove the merge nor how to merge the cells in the same fashion. Could you explain a little bit more how to do those two I am very appreciated

Mar 14th, 2002, 06:12 AM	#5
Guest Posts: n/a	I am modifying a big spreadsheet for a company. I think someone merged the cells all over the spreadsheet. Is there a way to remove the merge at once? Thanks in advance

Mar 14th, 2002, 06:16 AM	#6
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	If you highlight the entire sheet, then do the same thing that Aladin sugested, that will work. The merge cells checkbox will be a dullened grey, but you can still uncheck it

Mar 14th, 2002, 06:17 AM	#7
Guest Posts: n/a	When I go to Format->cell->remove merge check box I got a "Too Many Different Cell Formats" error message What should I do now? Please Help Thanks in advance