How do I create a drop down sort box?
 

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/comm...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



AT wrote:
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/comm...excel.newusers

Thanks George!!!! :)

"George Gee" wrote:

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



AT wrote:
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/comm...excel.newusers