View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Excel Data Sorting

OK, so you have the sheet filtered and are attempting to sort after
filtering? That will sort the visible cells, but that means they sort
everywhere within the sheet.

You can sort first, then filter. This all depends on what you are trying to
do.

"Cheryl" wrote:

I am not a technical person and this might be the wrong group, but I have to
start somewhere. I have autofilters on my excel (2003 version) spreadsheet,
but when I try to sort within the filters it does not sort correctly...it
leaves in things I don't want and separates the data I do want with some of
that I don't want. This leaves me with incorrect numbers for reports. Any
Suggestions please?

Cheryl