Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
help with mas data
 
Posts: n/a
Default getting msg: cannot sort merged cells not same size

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   Report Post  
Duke Carey
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort columns containing merged cells. Ron Excel Discussion (Misc queries) 1 May 4th 05 01:08 PM
TRYING TO SORT, MERGED CELLS HAVE TO BE IDENTICAL? ELIZABETH Excel Discussion (Misc queries) 1 May 3rd 05 04:40 AM
How to sort merged cells Sort merged cells Excel Worksheet Functions 3 March 11th 05 04:07 PM
How to sort merged cells imaorange Excel Worksheet Functions 0 March 11th 05 03:41 PM
Sorting merged cellsHow do I sort merged cells not identically siz Laval Excel Worksheet Functions 1 November 3rd 04 09:40 PM


All times are GMT +1. The time now is 03:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"