+ Reply to Thread
Results 1 to 4 of 4

How do I sort while keeping integrity of the rest of the sheet

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

    How do I sort while keeping integrity of the rest of the sheet

    How do I sort but have the other data move with the column I'm sorting? Whenever I sort, for example, by name, the address and phone numbers columns stay the same and are therefore incorrect with the newly sorted columns. I've looked everywhere.

  2. #2
    Registered User
    Join Date
    03-29-2007
    Location
    Missouri, USA
    Posts
    29
    I'd add an autofilter to your report.

    select the title row, go up to data, go to filter, go to autofilter. This will allow you to sort, and sorts all of the accompanying data with it

  3. #3
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,881
    Sam,

    Simply select the entire sheet prior to sorting. Click the small gray box to the left of column A and above row 1, then click Data -> Sort...

    Sort by whichever columns you want, all your data will stay together.

    If there are tables of data in other sections of the worksheet that you don't want changed when you sort another section, simply select the range of cells in that section (for example, A15:G500) and then use Data -> Sort...

  4. #4
    Registered User
    Join Date
    08-01-2007
    Posts
    8

    thanks!

    Gosh you all made it seem so easy. I've wasted HOURS trying to figure out how to sort without messing up the other columns.

    Thanks so much!

    Sam in Cuthbert, Georgia

+ 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