How to protect only the data cells in a spreadsheet
I would like to only protect the data cells in a spreadsheet
First time here? Check out the FAQ!
I would like to only protect the data cells in a spreadsheet
Ctrl+Shift+Space Bar
).Format
- Cells…
(the same that Ctrl+F1
), Cell Protection
tab, uncheck Protected, OK
.Format
- Cells…
, Cell Protection
tab, check Protected, OK
.Tools
- Protect Sheet
, select (or not) a password, OK
.More LibreOffice Help on Protecting Cells from Changes.
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.
Asked: 2017-10-28 15:26:14 +0100
Seen: 55 times
Last updated: Oct 18 '20
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]