Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I create a monthly calender as a drop down list in excel? | Excel Discussion (Misc queries) | |||
How do I create calendar drop down box | Excel Discussion (Misc queries) | |||
Trying to create repeating dates and then sort column by date | Excel Worksheet Functions | |||
Create a drop down in XL cell to select date | Excel Worksheet Functions | |||
how do I create a drop down menu in Excell? | Excel Worksheet Functions |