Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort part of a filtered spreadsheet
A user has an issue trying to sort on a selected range of data in a filtered
spreadsheet. Says she was able to do this in Excel 2003 and now cannot in Office 2007. Data was originated from a query. Data is in sections and wants to just sort a particular section. When trying to do this, it sorts entire worksheet. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort part of a filtered spreadsheet
Can't imagine why you would want to do this but:
Select the range of data that she wants sorted. Then "sort and filter" and select criteria. When the "Sort Warning" window pops select "Continue with the current selection". Be careful doing this because it "unsynchronises" your database. If this helps please click "Yes" <<<<<<<<<< "jfaulks" wrote: A user has an issue trying to sort on a selected range of data in a filtered spreadsheet. Says she was able to do this in Excel 2003 and now cannot in Office 2007. Data was originated from a query. Data is in sections and wants to just sort a particular section. When trying to do this, it sorts entire worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting part of a Spreadsheet into the Current Spreadsheet | Excel Discussion (Misc queries) | |||
Filtered spreadsheet performance | Excel Worksheet Functions | |||
Sort by part of a number | New Users to Excel | |||
Data Sort 2 part question | Excel Discussion (Misc queries) | |||
How sort filtered file. | New Users to Excel |