ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to unprocted certain cell (https://www.excelbanter.com/excel-discussion-misc-queries/223855-how-unprocted-certain-cell.html)

Kim

How to unprocted certain cell
 
Hi,

I've protected the whole sheet but I need some of the cell in the sheet to
be unprotected. How can I go about?

Regards,

Eduardo

How to unprocted certain cell
 
Hi Kim,
Unprotect the sheet, highlight the cell you want to be unprotected, right
click in the mouse, format cells, last tab is protection, uncheck the box
that says locked, protect again the sheet


"Kim" wrote:

Hi,

I've protected the whole sheet but I need some of the cell in the sheet to
be unprotected. How can I go about?

Regards,


Bob I

How to unprocted certain cell
 
UNlock the cells in question before protecting the sheet. (Format Cells
Protection UNcheck "Locked")

Kim wrote:

Hi,

I've protected the whole sheet but I need some of the cell in the sheet to
be unprotected. How can I go about?

Regards,




All times are GMT +1. The time now is 05:59 AM.

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