Advanced Spreadsheets – Security

Add, remove password protection for a spreadsheet: to open, to modify.

To add password protection for a spreadsheet, click on ‘File’ from the main menu bar and from the resulting drop-down, click on ‘Save As’. This will open the ‘Save As’ dialog box. In this dialog box, we have a ‘Save with password’ checkbox. Check this checkbox in order to enable password protection for the spreadsheet. After this click on ‘Save’.


Security (1)
Security (2)
Security (3)
Security (4)
Security (5)
Security (6)
Security (7)
Security (8)
Security (9)
Security (10)
Security (11)
Security (12)
Security (13)
Security (14)
Security (15)
Security (16)
Security (17)
Security (18)
Security (19)
Security (20)
Security (21)
Security (22)
Security (23)

Save with password 6
This will open the ‘Set Password’ dialog box. In this dialog, enter the password and then click on ‘OK’. This will add the password for opening the file.

If you want to add the password for modification of file as well, then maximize the ‘Options’ area in this dialog box and check the ‘Open file read-only’ checkbox. After this, enter the password for file editing and click on ‘OK’. This will always open the file as a read only file and will ask the users for this password in case they need to make any modifications to the file.

Read Only 7

Protect, unprotect cells, worksheet with a password.

To protect a worksheet with a password, click on ‘Tools’ from the main menu bar. From the resulting drop-down, click on ‘Protect Document’ and from the sub-menu, click on ‘Sheet’. This opens the ‘Protect Sheet’ dialog box.

Protect 8

Enter the appropriate password here and click on ‘OK’. This will make the worksheet password protected. We also have two checkboxes in this dialog; these can be checked according to the requirements.

Hide, unhide formulas.

To hide or unhide formulas in the worksheet, click on ‘Tools’ from the main menu bar. From the resulting drop-down, click on ‘Options’. This opens the ‘Options’ wizard. In the ‘Options’ wizard, under ‘LibreOffice Calc’, click on ‘View’. Then under ‘Display’, we have a checkbox called ‘Formulas’. If this checkbox is checked, then the formulas will be shown in the worksheet instead of the results, but if the checkbox is unchecked, then the results of the formulas will be shown. This is how we can hide or unhide formulas.

Hide Formula 9