sort part of a filtered spreadsheet

[jfaulks]

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.

 

[BSc Chem Eng Rick]

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