Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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... |
#2
|
|||
|
|||
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 formatalignment center across selection. There is no way you can sort merged and non merged cells together -- Regards, Peo Sjoblom "Sort merged cells" <Sort merged wrote in message ... 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... |
#3
|
|||
|
|||
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 formatalignment center across selection. There is no way you can sort merged and non merged cells together -- Regards, Peo Sjoblom "Sort merged cells" <Sort merged wrote in message ... 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... |
#4
|
|||
|
|||
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 formatalignment center across selection. There is no way you can sort merged and non merged cells together -- Regards, Peo Sjoblom "Sort merged cells" <Sort merged wrote in message ... 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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Thumbnail pictures in cells don't sort with rest of row | Excel Discussion (Misc queries) | |||
Auto fit merged cells | Excel Discussion (Misc queries) | |||
paste info into merged cells | Setting up and Configuration of Excel | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions | |||
How do I "Wrap Text" & "Autofit" within Merged Cells in Excel? | Excel Worksheet Functions |