sort part of a filtered spreadsheet

J

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.
 
B

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

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

Top