+ Reply to Thread
Results 1 to 3 of 3

Data Sort & Merged cells

  1. #1
    Registered User
    Join Date
    07-08-2008
    Location
    lake
    Posts
    10

    Data Sort & Merged cells

    Hi everyone,
    I'm having trouble sorting some data. I select the data i want sorted, then choose how to sort the data, but when i click "ok" it says, "this operation requires the merged cells to be identically sized."

    Unfortuantely i did not create this spreadsheet. I am unable to locate ANY merged cells. The only difference i was able to find was that some rows were different heights. I have formatted all rows to be the same height and still no luck. Any ideas on how to locate the merged cells? Suggestions?

    Thanks
    HQH2O

  2. #2
    Registered User
    Join Date
    05-06-2009
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    85

    Re: Data Sort & Merged cells

    If the gridlines are showing and there are no colors, you will be able to tell by following the gridlines which are merged.

    When I come across that, I just always Select All and Un-merge the cells.
    You have to be a wee bit careful with that because it may put things in weird spots. Save a copy of the file so you can always go back to the original if it was messed-up, but try it.

  3. #3
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243

    Re: Data Sort & Merged cells

    hi,

    Here are some solutions:

    http://www.excelassist.co.uk/2009/02...lls-using-vba/
    http://www.pcreview.co.uk/forums/thread-2743746-2.php
    http://www.excelforum.com/excel-misc...ged-cells.html
    These were all sourced from http://www.google.com/search?q=%22fi...meta=&aq=f&oq=

    If the above links donšt help, can you attach a copy of the problem file with any confidential data removed for helpers to peruse?

    hth
    Rob
    Rob Brockett
    Kiwi in the UK
    Always learning & the best way to learn is to experience...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1