sorting in Excel

  • Thread starter Thread starter Oran Walker
  • Start date Start date
O

Oran Walker

I inherited an Excel document that, when I go to sort,
has the sort choice set to always be "header row" with
first sort being "last name" and second sort being "first
name." I'd like to set up the sort function in a new
document the same way. How do I do that? Thanks. OW
 
Hi
AFAIK Excel stores this information after your first sort. So simply
set in your new table the sorting according to your requirements. Excel
should remember these settings as default
 
Thank you for your reply. Unfortunately, Excel is not
remembering the settins after the first sort. I have to
reset them every time. Cordially, Oran
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

writing a sort macro 2
stop sorting titles please 3
Excel "remembering" sort criteria 3
Sort confusion 2
Columns not sorting properly. 2
Sorting issue with frozen panes 11
Sorting 1
How to sort entire spreadsheet by one column sort 5

Back
Top