Ask Your Question

multiple passwords on libre sheets

asked 2019-09-02 18:22:17 +0200

cleansoul4u2 gravatar image


Is it possible to have multiple password on one sheet in order to protect cells. If have created if excel sheet for three uses and need to protect three columns for reporting. I can can do it in MS excel but I want to use an open source app.

Thank you

edit retag flag offensive close merge delete


Guys i am trying to get away from MS Excel

cleansoul4u2 gravatar imagecleansoul4u2 ( 2019-09-02 19:32:38 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-09-02 18:46:17 +0200

erAck gravatar image

Multiple passwords for individual cell ranges on one sheet are not possible. One sheet can have one password to protect cells, so you'd have to set-up three individual sheets for this case and pull the data into a reporting sheet using cell references.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-09-02 18:22:17 +0200

Seen: 19 times

Last updated: Sep 02