1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Sort in Excel

Discussion in 'Business Applications' started by yankeesfan, Jul 9, 2007.

Thread Status:
Not open for further replies.
Advertisement
  1. yankeesfan

    yankeesfan Thread Starter

    Joined:
    Jan 4, 2007
    Messages:
    41
    Is there a way to sort a page without changing the header.
    I know how to go in to the tools>sort> then select header row so it excludes it.
    But is there a way to configure that setting everytime to the Quick sort icon???
     
  2. gdi1942

    gdi1942

    Joined:
    Nov 1, 2006
    Messages:
    215
    can't you just select the rows you want, including the headers and press the quick sort icon. I think that's how it's done anyway. Just a guess
     
  3. Couriant

    Couriant Trusted Advisor

    Joined:
    Mar 26, 2002
    Messages:
    34,608
    First Name:
    James
    You are correct, just don't include the headers.

    Alternatively, make your data into a list (Insert > List). Then you can sort without moving the headers when using the sort button. Note that it will sort by the first column, then the second, and so forth.
     
  4. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    There is not a way to set this as the default in the quick sort, however, you can add a Sort button to your Toolbar (Customize, Data - it is at the top) which will bring up the same thing as Tools, Sort.
    Sadly, it looks just like the Sort Ascending button, so you should put it on another toolbar.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/593748

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice