ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   To Protect Excel documents and allowing only few cells to edit (https://www.excelbanter.com/excel-worksheet-functions/80311-protect-excel-documents-allowing-only-few-cells-edit.html)

DHANRAJ

To Protect Excel documents and allowing only few cells to edit
 
I would like to Protect a Excel Sheet leaving only few rows for editing(data
entry) purpose how this can be done. If I give protect sheet the whole
document is protected and I am unable to edit.

Bondi

To Protect Excel documents and allowing only few cells to edit
 
Hi Dhanraj,

Select the rows you want to enter data into. Right click and choose
Format Cells -Protection. Then uncheck Locked. Then go to Tools -
Proctecion - Protect Sheet and accept default.

Best regards,
Bondi



All times are GMT +1. The time now is 08:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com