Sort in Excel

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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???
 
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
 

Couriant

James
Moderator
Joined
Mar 26, 2002
Messages
39,882
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.
 
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Staff online

Top