How do I create a drop down sort box?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to sort a column with a header by 3 options that can be entered in the
box - A,B or C. I want to create a box that when A is chosen, all the rows
with A in column B are listed and the others are hidden. How is this created?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...d21ce5f8c7&dg=microsoft.public.excel.newusers
 
Hi AT


Click on a cell in column B,
Data > Filter > Autofilter.

Click on the down arrow at the top of Column B and click on 'A' in the
dropdown list.
This should list all the A's in Column B, and hide the rest.
To show all rows again: Data > Filter > Show all.

HTH

George Gee


I want to sort a column with a header by 3 options that can be
entered in the box - A,B or C. I want to create a box that when A is
chosen, all the rows with A in column B are listed and the others are
hidden. How is this created?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click
the "I Agree" button in the message pane. If you do not see the
button, follow this link to open the suggestion in the Microsoft
Web-based Newsreader and then click "I Agree" in the message pane.
Click to expand...
http://www.microsoft.com/office/com...d21ce5f8c7&dg=microsoft.public.excel.newusers
 
Back
Top