Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Quick Question
I made up a list of vendors that I use pretty much on a daily basis. Its sort
of like my own phone book. Is there any way that if i needed to get to "S" That i can do something and put in "S" and all the companies starting with S will show up? |
#2
|
|||
|
|||
Quick Question
You can use autofiltering (Data - Filter - AutoFilter). From drop down list
select "custom" and set filter condition "s". Excuse me, I don't use English version. Before you use this, you need in first row names of columns (name, city, tel, etc) peter b. "Jenn" wrote: I made up a list of vendors that I use pretty much on a daily basis. Its sort of like my own phone book. Is there any way that if i needed to get to "S" That i can do something and put in "S" and all the companies starting with S will show up? |
#3
|
|||
|
|||
Quick Question
This can be done with a combobox from the control toolbox.
-- HTH RP (remove nothere from the email address if mailing direct) "Jenn" wrote in message ... I made up a list of vendors that I use pretty much on a daily basis. Its sort of like my own phone book. Is there any way that if i needed to get to "S" That i can do something and put in "S" and all the companies starting with S will show up? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Excel Colours - Quick Question | Excel Discussion (Misc queries) | |||
Quick formula question | Excel Worksheet Functions | |||
Quick question: What does "--" in an equation do? | Excel Worksheet Functions | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions |