How to protect only the data cells in a spreadsheet

jdensie
1 ●1 ●1

I would like to only protect the data cells in a spreadsheet

1 Answer

Sort by » oldest newest most voted

3797 ●5 ●71 ●71

Select all the cells (Ctrl+Shift+Space Bar).
Choose menu Format - Cells… (the same that Ctrl+F1), Cell Protection tab, uncheck Protected, OK.
Select the data cells.
Choose menu Format - Cells…, Cell Protection tab, check Protected, OK.
Choose menu Tools - Protect Sheet, select (or not) a password, OK.

Tested with LibreOffice 6.3.6.2 (x86); OS: Windows 6.1.

Add Answer is reserved for solutions.

Press edit below your question if you want to add more information; also can comment an answer.

Check the mark () to the left of the answer that solves your question.

1 follower

Asked: 2017-10-28 15:26:14 +0100

Seen: 55 times

Last updated: Oct 18 '20