Password for rows and columns

  • Thread starter Thread starter Clifford Thomas
  • Start date Start date
C

Clifford Thomas

Is there a way to hide a row & column with a password in a worksheet, in such
a way that the other user should be able to work on the same worksheet but
with the remaining rows & columns, without being able to open the hidden row
& column
 
Hi

As standard all cells are set to be protected, when you protect a sheet.

Select the cells, rows or columns where other users shall be able to enter
data, then goto Format > Cells > Protection : Remove the check in "Locked".

Hide the desired column / row. Protect the sheet (with password).

Now the user can enter data as desired, byt they can not hide/unhide rows or
columns.

Hopes it helps

Regards,
Per
 
Back
Top