Ask Your Question

hoe do i leave certain cells unprotected on a spreadsheet

asked 2018-04-01 23:18:48 +0200

CARciergeKINDRED gravatar image

when protecting a spreadsheet how do i leave specific cells unprotected so a user can answer a drop down menu?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-04-02 01:16:01 +0200

m.a.riosv gravatar image

Menu/format/cells [Ctrl+1], Cell protection tab.

It works in combination with the sheet protected: Menu/Tools/Protect sheet.

So if the sheet it's protected then cell protection it's applied. page 33.

edit flag offensive delete link more

answered 2018-04-02 12:33:19 +0200

peterwt gravatar image

When you create a new spreadsheet the protected attribute is set to protected for all cells. Right click on a cell you do not want to be protected, select "Format Cells" and the "Cell Protection" tab. Uncheck the protected box. You will notice it states here "Cell protection is only effective after the current sheet has been protected."

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-04-01 23:18:48 +0200

Seen: 61 times

Last updated: Apr 02 '18