View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
sheila4typing sheila4typing is offline
external usenet poster
 
Posts: 5
Default Excel 2007 - Sorting 3 columns

Hi Jim,
I think I understand. Can you help me do this. Basically I need to
sort/filter on column A (have that info stay) then sort column B (have that
info stay along with column A) etc.

"Jim Rech" wrote:

It sounds to me that you're not sorting but rather filtering. When you
apply filters to more than one column you get only the records that match
all the filters. If what you really want are the records that meet any of
the criteria you have to use Advanced Filter on the Data tab. Write back if
you need help on this.

--
Jim
"sheila4typing" wrote in message
...
|I am not very good with Excel nor 2007 version so hopefully I can explain
| this so you can understand.
| I have an excel spreadsheet for work that I am trying to sort 3 columns at
| once. Column A is titled Classes, Column B is Grades and Column C is
Type.
| I turned on the filter sor sorting and used the down arrow of Column A to
| select what Classes I wanted and it did fine; however when I try to do the
| same on Column B it only sorted Column B and did not show my my sorts in
| Column A. The same for Column C, when I select what i want it does not
show
| me my selection for Column A and B.
| If this does not make since I can attach the document and show you, but I
am
| not sure how to do this.
| Can you help with this?
| Thanks