sorting list that includes merged cells
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: sorting list that includes merged cells

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Any tips out there on how to easily unmerge or delete cells that are included in a list that I would like to sort? The data that I am interested in are not included in the merged cells, so I do not care if those cells are completely lost or not.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,864
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-04-16 11:21, shammer wrote:
    Any tips out there on how to easily unmerge or delete cells that are included in a list that I would like to sort? The data that I am interested in are not included in the merged cells, so I do not care if those cells are completely lost or not.
    Free ASAP-Utilities has an option to unmerge selected cells, downloadable at:

    asap-utilities.com

    if your OS is Windows.


    [ This Message was edited by: Aladin Akyurek on 2002-04-16 12:18 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    its notgoing to lilike merge cells... suggest un merge first or add col and sort...

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com