Who is good at Excel? Need quick help
| Posted By | Message |
|---|---|
|
NervousNell
Member since 11/09 54921 total posts Name: |
Who is good at Excel? Need quick help Someone else created the spreadsheet and I need to go in an add something. |
Posted 1/23/18 2:23 PM
|
|
|
Long Island Weddings
Long Island's Largest Bridal Resource
| |
|
Re: Who is good at Excel? Need quick help Is the list for the column or the cell? Did she just add a filter to that column? If that is what she did, all you need to do is add your item to an empty cell and it will appear in the list. |
|
Posted 1/23/18 2:34 PM
|
|
|
NervousNell
Member since 11/09 54921 total posts Name: |
Re: Who is good at Excel? Need quick help It's just one cell. |
Posted 1/23/18 2:36 PM
|
|
|
Re: Who is good at Excel? Need quick help Is it a comment maybe? Does the cell have a red triangle in the corner and is the list in a yellow box? |
|
Posted 1/23/18 2:39 PM
|
|
|
NervousNell
Member since 11/09 54921 total posts Name: |
Re: Who is good at Excel? Need quick help Hmmm no it doesn't. |
Posted 1/23/18 2:45 PM
|
|
|
Re: Who is good at Excel? Need quick help The drop down menu is pulling from a list. Do you know where she has the list stored? It's probably on a hidden worksheet. |
|
Posted 1/23/18 2:54 PM
|
|
|
Who is good at Excel? Need quick help I haven't used Excel for a really long time, but look for something called "data validation". And then it might be called "restricted values" and maybe something to check of about a drop down box. |
|
Posted 1/23/18 2:57 PM
|
|
|
NervousNell
Member since 11/09 54921 total posts Name: |
Re: Who is good at Excel? Need quick help Posted by lululu The drop down menu is pulling from a list. Do you know where she has the list stored? It's probably on a hidden worksheet. Yes that is what I thought. It most likely is hidden because this spreadsheet goes to our customers for when they are requesting work. It has their site locations listed. I have to try to find it- unless she gets back to me before that. |
Posted 1/23/18 2:58 PM
|
|
|
Re: Who is good at Excel? Need quick help Posted by pumpkinmom I haven't used Excel for a really long time, but look for something called "data validation". And then it might be called "restricted values" and maybe something to check of about a drop down box. Yes you have to go to data validation and it will tell you the cell range of the list. I want to say in the data tab.. Usually people will put it all the way to the rightt or way down in rows Message edited 2018-01-23 15:16:53.373000. |
|
Posted 1/23/18 3:16 PM
|
|
|
Re: Who is good at Excel? Need quick help Posted by NervousNell Posted by lululu The drop down menu is pulling from a list. Do you know where she has the list stored? It's probably on a hidden worksheet. Yes that is what I thought. It most likely is hidden because this spreadsheet goes to our customers for when they are requesting work. It has their site locations listed. I have to try to find it- unless she gets back to me before that. Right click on a tab and see if she hid one of the tabs that created a list? |
|
Posted 1/23/18 3:24 PM
|
|
|
NervousNell
Member since 11/09 54921 total posts Name: |
Re: Who is good at Excel? Need quick help Posted by RainyDay Posted by NervousNell Posted by lululu The drop down menu is pulling from a list. Do you know where she has the list stored? It's probably on a hidden worksheet. Yes that is what I thought. It most likely is hidden because this spreadsheet goes to our customers for when they are requesting work. It has their site locations listed. I have to try to find it- unless she gets back to me before that. Right click on a tab and see if she hid one of the tabs that created a list? Ah ha! That did it. I found a hidden tab with the list of locations! Like magic! Thank you!
|
Posted 1/23/18 3:31 PM
|
|
Potentially Related Topics:
| Topic | Posted By | Started | Replies | Forum |
|---|---|---|---|---|
| Quick request for good job vibes for DH...UPDATED | MsMBV | 6/19/07 | 27 | Families Helping Families ™ |
| Quick Dessert and it was good too | july06bride | 1/6/07 | 0 | Dining In or Out |
| A good quick, easy, sexy read... | Jagster2000 | 9/17/06 | 0 | StoryBoard |
| A Good (Quick) Way To Lose 10 Lbs??? | Jesaroo | 1/25/06 | 2 | Diet & Fitness |
| Just a quick Good luck this week | dm24angel | 6/29/05 | 14 | TTC |
| Quick SD question: Is Levittown SD considered good? | BabyAvocado | 6/9/05 | 5 | Families Helping Families ™ |







