Can I make a range of cells in a worksheet read only ?

[Reetesh B. Chhatpar]

Hi,

Select Cell Range
Go Format -> Cells -> Protection
Uncheck "Locked" checkbox
Go Tools -> Protection -> Protect Sheet
*optional: specify password (its case sensitive)

I hope this helps !

Reetesh B. Chhatpar
ShawMan Software Enterprises
www.shawmansoftware.com

Diamond is just another piece of coal that did well under pressure.

 

[La Durande]

This protects the whole sheet. I require to have a block of cells on a
worksheet read only allowing other cells to have data added

 

[Frank Kabel]

Hi
- first select the cells for which you want allow entries
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- now protect the sheet

 

[Reetesh B. Chhatpar]

Hi,

Press CTRL+A to select all cells of Active Sheet
Go Format->Cells->Protection
Uncheck "Locked" Checkbox
Use CTRL key and select all those cells which you want to keep locked for
other users
Go Format->Cells->Protection
Check "Locked" Checkbox
Go Tools -> Protection -> Protect Sheet
*optional: specify password (its case sensitive)

I hope this helps ! Should there be any further queries, please feel free to
contact : (e-mail address removed)

Reetesh B. Chhatpar
ShawMan Software Enterprises
www.shawmansoftware.com

Diamond is just another piece of coal that did well under pressure.