Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi. someone sent me what looks like a run of the mill excel file . When I
try to sort it I get a message saying the "operation requires merged cells to be identically sized". All the cells look the same size to me and as far as I know no merging was done to create the file.... I am attempting to contact the creator of the file but so far no luck. any ideas? Thank you. |
#2
![]() |
|||
|
|||
![]()
press Ctrl-A to select the entire sheet, then FormatCellsAlignment and make
sure the Merge Cells option is unchecked. "help with mas data" wrote: Hi. someone sent me what looks like a run of the mill excel file . When I try to sort it I get a message saying the "operation requires merged cells to be identically sized". All the cells look the same size to me and as far as I know no merging was done to create the file.... I am attempting to contact the creator of the file but so far no luck. any ideas? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort columns containing merged cells. | Excel Discussion (Misc queries) | |||
TRYING TO SORT, MERGED CELLS HAVE TO BE IDENTICAL? | Excel Discussion (Misc queries) | |||
How to sort merged cells | Excel Worksheet Functions | |||
How to sort merged cells | Excel Worksheet Functions | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |