Hide contents of drop-down list in Excel with password

0 votes
I'm attempting to password-protect drop-down list entries in Excel. The drop-down menu can now only be accessed by entering a password, however, you may still see all options by clicking on the cell without one.

I essentially want to conceal certain items so that only users with the password can see them.

Protection of the sheet and in-cell dropdown for data validation
Feb 3, 2023 in Others by Kithuzzz
• 38,000 points
629 views

1 answer to this question.

0 votes

So, 3 versions all relatively similar:

enter image description here

Above shown with thew correct password entered.

Below without:

enter image description here

Now with a range with Data validation, with and without password:

enter image description here

enter image description here

answered Feb 3, 2023 by narikkadan
• 63,640 points

Related Questions In Others

0 votes
1 answer

How to create a drop-down list in Excel?

Making a list of the items you ...READ MORE

answered Oct 9, 2022 in Others by narikkadan
• 63,640 points
693 views
0 votes
1 answer

Get column names of Excel worksheet with OpenPyXL in readonly mode

This will print every thing from row ...READ MORE

answered Oct 22, 2022 in Others by narikkadan
• 63,640 points
7,197 views
0 votes
1 answer

How do I combine the first character of a cell with another cell in Excel?

Try this: =CONCATENATE(LEFT(A1,1), B1) READ MORE

answered Nov 7, 2022 in Others by narikkadan
• 63,640 points
1,455 views
0 votes
1 answer
0 votes
1 answer

Navigate Excel Drop-Down List via Keyboard

You are aware of the auto-complete feature ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 63,640 points
562 views
0 votes
1 answer

Create Drop-Down List Using a Formula (Without Data Validation)

As far as I am aware, it ...READ MORE

answered Nov 8, 2022 in Others by narikkadan
• 63,640 points
2,965 views
0 votes
1 answer

Excel data validation list

We can use nested if - if ...READ MORE

answered Dec 16, 2022 in Others by narikkadan
• 63,640 points
695 views
0 votes
1 answer
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,640 points
1,063 views
0 votes
1 answer

On focus after tabbing of Excel drop down, automatically show list for selection

Put the following code in the Microsoft ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,640 points
628 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP