Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I save my 'sort criteria' in an Excel file?
Having established a sort order over 3 columns in a file, I find that it
works quite well with no problems. When I return to that file after inserting new data, and wish to re-sort to the previous established sort order, I find that I have to go through the 3 columns again to set my order. There does not appear to be any way to save that sort order for that particular file. I am using Microsoft Excel 2000 v 9.0.6926 SP3 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I save my 'sort criteria' in an Excel file?
As long as the sort range has not changed dramatically, Excel should remember the previous sort used. Option 1: Instead of using a specific range (A1:C100) you might try sorting the entire columns (A:C). All of the blank items should go to the bottom..and as long as you don't have totals, it should work the same without any extra tweaking. Option 2: Create a macro to do the specific kind of sort you want. Then just run your macro every time (I've used that for some sorts I do just so that I don't have to click "Data-Sort-OK" all of the time). -- Lotus123 ------------------------------------------------------------------------ Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611 View this thread: http://www.excelforum.com/showthread...hreadid=486243 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I save my 'sort criteria' in an Excel file?
Could U set up a custom view for the data that you to retrieve?
I have used that for same criteria data that was repetitious, I customized various views pulling the fields of info I needed for a particular report. It was a 'quick fix' for what I needed and not enough time/experience to figure it all out.. "Jobod" wrote in message ... Having established a sort order over 3 columns in a file, I find that it works quite well with no problems. When I return to that file after inserting new data, and wish to re-sort to the previous established sort order, I find that I have to go through the 3 columns again to set my order. There does not appear to be any way to save that sort order for that particular file. I am using Microsoft Excel 2000 v 9.0.6926 SP3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO YOU GET EXCEL TO ASK IF YOU WANT TO SAVE A FILE ON EXITING | Excel Discussion (Misc queries) | |||
Save file in excel | Setting up and Configuration of Excel | |||
Excel prompts me to save a copy or overwrite file. | Excel Worksheet Functions | |||
How save a lotus 2.2 file in excel and to open it in excel and pe. | New Users to Excel | |||
How do I save a copy of an excel file without the formulas? | Excel Worksheet Functions |