Sorting will not work

Tech-Archive recommends: Fix windows errors by optimizing your registry



Hello,

Newbie here. Hello to all.

This is my issue.

I try to sort and I receive this message:

"The operation requires the merged cells to be identically sized."

How do I fix this?

Do I unmerge all the merged cells to see if they are identically sized;
then somehow redesign my Excel list?

I look forward to the answer(s).

.



Relevant Pages

  • Re: How can I sort one column and have the entire row sort. (bindi
    ... >> the rows and columns to have all the merged cells the same size. ... >> data and chose the state column for the sort. ... I Know they are the exact size. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: How do I sort a table w/ merged cells
    ... Tom, Good idea except my boss won't be too happy when I push all his summary ... How do I sort a table containing merged cells? ...
    (microsoft.public.excel.programming)
  • Re: excel sorting
    ... That is why you should avoid merged cells like the plague, ... "Baba" wrote in message ... excel will only sort that column. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How to sort with merged rows
    ... I also want to keep it under one page so I can print it out for review on a daily basis. ... The first problem is that when I try to sort, excel keeps saying "this operation requires the merged cells to be identically sized" ... Even if I do get by that problem, how can I keep the notes and the contact/data info above it together when I use a sort. ...
    (microsoft.public.excel.newusers)
  • Re: Sorting Merged Cells
    ... a table containing merged cells" warning. ... When I got the message, "Cannot sort a table containing merged cells," my ... You can use commas, as long as commas do not ...
    (microsoft.public.word.tables)