How to sort merged cells

I created a spreadsheet with a few merged cells. i would like to sort them,
by any colum, but i get an error saying operation requires merged cells to be
identically sized. What should i do so i can sort how i want...

Frankly stay away from merged cells unless yoiu are using them for headers,
they will always cause problems especially when it comes to sorting or copy
and pasting. I have not used merged cells for several years and I have
notsuffer from it, quite the contrary. You can get similar design using
format>alignment center across selection. There is no way you can sort
merged and non merged cells together


--

Regards,

Peo Sjoblom



"Sort merged cells" <Sort merged cells@discussions.microsoft.com> wrote in
message news:41211105-B59F-4AAF-A274-2911383901A0@microsoft.com...
> I created a spreadsheet with a few merged cells. i would like to sort
them,
> by any colum, but i get an error saying operation requires merged cells to
be
> identically sized. What should i do so i can sort how i want...

Thank you for the input- im going to figure something else out!

"Peo Sjoblom" wrote:

> Frankly stay away from merged cells unless yoiu are using them for headers,
> they will always cause problems especially when it comes to sorting or copy
> and pasting. I have not used merged cells for several years and I have
> notsuffer from it, quite the contrary. You can get similar design using
> format>alignment center across selection. There is no way you can sort
> merged and non merged cells together
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
>
> "Sort merged cells" <Sort merged cells@discussions.microsoft.com> wrote in
> message news:41211105-B59F-4AAF-A274-2911383901A0@microsoft.com...
> > I created a spreadsheet with a few merged cells. i would like to sort
> them,
> > by any colum, but i get an error saying operation requires merged cells to
> be
> > identically sized. What should i do so i can sort how i want...
>
>
>

Thank you for the input! Im going to figure something else out

"Peo Sjoblom" wrote:

> Frankly stay away from merged cells unless yoiu are using them for headers,
> they will always cause problems especially when it comes to sorting or copy
> and pasting. I have not used merged cells for several years and I have
> notsuffer from it, quite the contrary. You can get similar design using
> format>alignment center across selection. There is no way you can sort
> merged and non merged cells together
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
>
> "Sort merged cells" <Sort merged cells@discussions.microsoft.com> wrote in
> message news:41211105-B59F-4AAF-A274-2911383901A0@microsoft.com...
> > I created a spreadsheet with a few merged cells. i would like to sort
> them,
> > by any colum, but i get an error saying operation requires merged cells to
> be
> > identically sized. What should i do so i can sort how i want...
>
>
>