+ Reply to Thread
Results 1 to 2 of 2

Locking Rows for Column Sort

  1. #1
    Registered User
    Join Date
    03-01-2008
    Posts
    1

    Locking Rows for Column Sort

    I am a newbie for excel, so please excuse if this is a easy question.

    I am trying to lock the entire row so that when I sort by a column all data to left and right of the column sorted stays in the same rows as originally was with sorted data.

    Example

    a 9 8 7 6
    c 0 5 5 1
    b 8 3 0 5

    If sorted on column A new table would look like this

    a 9 8 7 6
    b 8 3 0 5
    c 0 5 5 1



    Thanks in advance for any help.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Just select all the columns you want to stay together before you do the sort.

+ 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