+ Reply to Thread
Results 1 to 2 of 2

only the first 5 columns of a 10 column excel spreadsheet sort

  1. #1
    jrw562
    Guest

    only the first 5 columns of a 10 column excel spreadsheet sort

    How do I get the whole spread sheet to sort? There is a blue lox for the
    first 5 columns that limits the range of the sort. How do I remove it?
    Using Office 2003.

  2. #2
    Dave Peterson
    Guest

    Re: only the first 5 columns of a 10 column excel spreadsheet sort

    Maybe if you remove the Data|list

    Select a cell in that blue box.
    Data|list|convert to range



    jrw562 wrote:
    >
    > How do I get the whole spread sheet to sort? There is a blue lox for the
    > first 5 columns that limits the range of the sort. How do I remove it?
    > Using Office 2003.


    --

    Dave Peterson

+ 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