ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how protec cell in excel? (https://www.excelbanter.com/excel-worksheet-functions/82499-how-protec-cell-excel.html)

Luis Moreno

how protec cell in excel?
 
I can´t protec cell in excel only there are options for protec sheet or work
book but there isn´'t to protec cell

Dave Peterson

how protec cell in excel?
 
Select the cells you want locked.
Format|cells|protection Tab|check Locked.

And select the cells you want unlocked
format|cells|protection tab|uncheck locked

Then tools|protection|protect sheet

Locked/unlocked cells won't mean much until the worksheet is protected.

And on top of that worksheet protection is easily broken. Don't try to protect
info that you don't want getting out. Excel doesn't have that kind of security.

Luis Moreno wrote:

I can´t protec cell in excel only there are options for protec sheet or work
book but there isn´'t to protec cell


--

Dave Peterson


All times are GMT +1. The time now is 10:01 AM.

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