Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 23rd 05, 08:19 PM
jimmy27298
 
Posts: n/a
Default Excel should remember sort criteria

Each time I sort a specific spreadsheet I have to select Data, Sort, No
header rows, column A, and Column B, then Sort. It would be great to define
a default sort for each spread sheet and then have that sort on the toolbar.
Whaddya think?

  #2   Report Post  
Old March 23rd 05, 08:27 PM
Fredrik Wahlgren
 
Posts: n/a
Default


"jimmy27298" wrote in message
...
Each time I sort a specific spreadsheet I have to select Data, Sort, No
header rows, column A, and Column B, then Sort. It would be great to

define
a default sort for each spread sheet and then have that sort on the

toolbar.
Whaddya think?


If you often need to sort, you're better of by recording what you do. Next
time, you simply run the generated macro.
Of course, you need to put the code in an add-in or personal.xls if you use
different workbooks.

/Fredrik


  #3   Report Post  
Old September 30th 05, 06:01 PM
Michael Miller
 
Posts: n/a
Default

I have a directly related question:
Excel XP, 2002, SP-2

We have multiple tabs and we sort them all the same way.
Normally, Excel remembers the sort and we don't have to do anything.
But, some tabs are not remembering their sort, where the Asc or Desc or
whether it remembers that there is a header row.

Why does Excel not remember the last sort used on a tab?

The file -is- shared, but the particular user had put in the sort parms,
live on screen, and when he returned to a particular tab, the parms were gone.

Thanks.

--
MichaelM


"Fredrik Wahlgren" wrote:


"jimmy27298" wrote in message
...
Each time I sort a specific spreadsheet I have to select Data, Sort, No
header rows, column A, and Column B, then Sort. It would be great to

define
a default sort for each spread sheet and then have that sort on the

toolbar.
Whaddya think?


If you often need to sort, you're better of by recording what you do. Next
time, you simply run the generated macro.
Of course, you need to put the code in an add-in or personal.xls if you use
different workbooks.

/Fredrik





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can i sort excel worksheets in alphabetical order? Birichica Excel Worksheet Functions 1 February 14th 05 07:25 PM
PASTE SUBTOTALS IN EXCEL TO ANOTHER SHEET TO DO ANOTHER SORT MIKE Excel Discussion (Misc queries) 1 January 27th 05 03:40 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 12:32 PM
HELP! How do you--> Lock a set of rows but also link worksheets to FRUSTRATED Excel Discussion (Misc queries) 6 December 29th 04 11:05 PM
> and < criteria in one single expression in excel ExcelLEarner New Users to Excel 1 December 5th 04 05:54 AM


All times are GMT +1. The time now is 02:26 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017