+ Reply to Thread
Results 1 to 4 of 4

How do I associate all data in a row for sorting with out it getting scrambled?

  1. #1
    Registered User
    Join Date
    09-27-2006
    Posts
    2

    How do I associate all data in a row for sorting with out it getting scrambled?

    I am creating a simple check register in Excel. I have set it up to look like a check register with all the data for a single check being entered into a row. I want to be able to sort the data by using the columns to sort ascending/descending and keep the data in the row intact, then sort by date, check number, amount, etc. When I currently do this only the data in the selected column sorts and it is no longer associated with other data in the row. I know I can double click in the upper most left cell to select all of the data and then sort but this limits my sorting options to one type of check attribute. So I guess my question is, Can I lock the data in a row so that it can be sorted by column and never scrambled or disassociated with the other data it is associated with in the row?

    Thanks in advance

    Daddy_O

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by Daddy_O
    I am creating a simple check register in Excel. I have set it up to look like a check register with all the data for a single check being entered into a row. I want to be able to sort the data by using the columns to sort ascending/descending and keep the data in the row intact, then sort by date, check number, amount, etc. When I currently do this only the data in the selected column sorts and it is no longer associated with other data in the row. I know I can double click in the upper most left cell to select all of the data and then sort but this limits my sorting options to one type of check attribute. So I guess my question is, Can I lock the data in a row so that it can be sorted by column and never scrambled or disassociated with the other data it is associated with in the row?

    Thanks in advance

    Daddy_O
    If you have only 1 header row, select All Data, otherwise select the rows that you require to be sorted, and sort over the column(s) required.

    ---

  3. #3
    Registered User
    Join Date
    09-27-2006
    Posts
    2

    Still looking for more efficiency

    Selecting individual rows would be time consuming with say 500 or more entries that I may want to sort. That is why I wanted to be able to do it in a more global sense, like by columnar attribute. So I would still like to know if it is possible to lock (associate) all of the data in a row and not allow it to be scrambled when sorting by column.

    Thanks

    Daddy_O

  4. #4
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by Daddy_O
    Selecting individual rows would be time consuming with say 500 or more entries that I may want to sort. That is why I wanted to be able to do it in a more global sense, like by columnar attribute. So I would still like to know if it is possible to lock (associate) all of the data in a row and not allow it to be scrambled when sorting by column.

    Thanks

    Daddy_O
    To select data on a column basis, use Data, Autofilter, then select the full rows displayed to sort. This should produce the results that you seek.
    ---

+ 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