+ Reply to Thread
Results 1 to 3 of 3

Sort data - except headers

  1. #1
    Registered User
    Join Date
    09-30-2011
    Location
    Lithuania
    MS-Off Ver
    Excel 2010
    Posts
    81

    Sort data - except headers

    Hello, I'm having trouble determining what setting I need to use so that when I sort a column, the headers stay put.

    Do I need to use a page break, or is there some way of selecting the top row and configuring it as a header? I'd rather not use the advance filter option to manually set headers each time.

    Thank you for any help you can offer!
    Nate
    Last edited by Nate Westcott; 02-13-2015 at 12:03 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Sort data - except headers

    Data => Sort => click on this file has headers.

    After that you can determine the sort criteria.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    09-30-2011
    Location
    Lithuania
    MS-Off Ver
    Excel 2010
    Posts
    81

    Re: Sort data - except headers

    Ahh right! I always use the A/Z and Z/A sort option. I'm not sure why the "headers" option is only in the "Sort" dialogue.

    Thank you -- solved!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] sort table data by selectable headers
    By bwanaal in forum Excel General
    Replies: 1
    Last Post: 04-04-2014, 06:01 AM
  2. Sort rows of data by date after last row entry with page headers
    By Mark GC in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2013, 09:19 AM
  3. [SOLVED] Headers Sort With Data
    By kwengerd in forum Excel General
    Replies: 4
    Last Post: 08-28-2012, 12:29 PM
  4. Replies: 3
    Last Post: 09-30-2010, 12:30 PM
  5. [SOLVED] how do you sort two columns; data and headers
    By Bolek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2005, 01:25 PM

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