+ Reply to Thread
Results 1 to 3 of 3

sort selected cells on shared workbook

  1. #1
    Registered User
    Join Date
    01-08-2007
    Posts
    1

    sort selected cells on shared workbook

    If our workbook is not shared we can sort selected cells. If it is shared the sort affects the entire rows.

    Is there a way to sort selected cells only in a shared workbook?

    TIA
    Lidna

  2. #2
    Forum Contributor
    Join Date
    11-29-2003
    Posts
    1,203
    Hi Inivin,

    Honestly, I don't have much experience with shared workbooks. So, this is a shot in the dark. But, since you haven't gotten any other responses in 8 hours, this might be as good as you're going to get, and it will cost you nothing to try my idea.

    How about ... unshare the workbook, sort the column, share the workbook again?

  3. #3
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by lnivin
    If our workbook is not shared we can sort selected cells. If it is shared the sort affects the entire rows.

    Is there a way to sort selected cells only in a shared workbook?

    TIA
    Lidna
    If you are unable to un-share the workbook, another option is to copy the selection to a blank sheet, Sort, then replace the sorted cells over the original.

    hth
    ---
    Si fractum non sit, noli id reficere.

+ 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