HELP!!!Sort Not Wolking
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: HELP!!!Sort Not Wolking

  1. #1
    Guest

    Default

     
    I have created a column to sort a spreadsheet. However, after I add a column on both sides of the sorting column. The column doesn't sort the entire spreadsheet and just sort itself
    Is there a way to solve this problem?
    Thanks in advance

  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    Charlottetown, PE, Canada
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    Are you using the sort button on the toolbar, or going to Data > Sort and choosing one of the options there?

    Have you highlighted all three columns that you want sorted?

    - Galto

  3. #3
    Guest

    Default

    I am using sort button. What I am doing is that I select the column that I want to sort by and click the sort button

  4. #4
    Guest

    Default

    The columns on the right of sorting column can't sort if I add one empty column to the right of the sorting column and the columns on the left of sorting column can't sort if I add one empty column to the left of the sorting column.
    Is there a way to solve this problem
    Thanks in advance

  5. #5
    New Member
    Join Date
    Feb 2002
    Location
    East Sussex
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I may be mistaken, but choosing a column to "sort by" and clicking the sort button will only sort that column, not the entire spreadsheet. If you want to sort the sheet, select the entire sheet by clicking to the left of A and above 1, then choose Tools > Sort, idenfity your header row, and choose the column(s) you wish to sort by.

    sc

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