How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask namstech Your Own Question

namstech, Electrical Engineer
Category: Microsoft Office
Satisfied Customers: 2126
Experience:  Expert in Microsoft Word, Excel, Powerpoint, Visio
Type Your Microsoft Office Question Here...
namstech is online now
A new question is answered every 9 seconds

I am trying to edit something in Excel and I cant remember

Customer Question

I am trying to edit something in Excel and I can't remember what I did. I created some drop down lists in a spreadsheet so a user could click on a cell and a drop down list would open and they would click one of the choices. I also set it up so that they would get a warning message if they tried to input something other than one of the choices in the drop down box. I am okay with creating the data validation. Where I am stuck is that I can't remember or find anywhere in the workbook where I created those lists / tables for the user to click on. I want to edit the lists and I can't find them anywhere on any of the tabs. I'm pretty sure that I didn't protected the workbook????? I think I just clicked on another tab and randomly created the lists but can't find where I did that??? Please help???
Submitted: 4 years ago.
Category: Microsoft Office
Expert:  namstech replied 4 years ago.

NA-eTech :

Hello, and welcome to JustAnswer!

NA-eTech :

What is your version of Excel?

Customer :

All set - I just figured it out. Thanks. I had the sheet hidden from view and had to unhide the specific sheet / tab I had hidden. Sorry to bother you.

NA-eTech :

Great to hear that its sorted now :).

NA-eTech :

Have a nice day

Customer :

Thanks you too

Related Microsoft Office Questions