Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel template - Protecting cells from entering additional data

Status
Not open for further replies.

usfpjc

MIS
Jan 1, 2002
27
0
0
US
I have created a worksheet where some cell rows have informational text and need to be restricted from entering additional data.
I want to protect that specific area by disabling it - ("read only").

How do I do it, without disabling the entire worksheet?
 
Format-Cells-Protection

lock the cells you want ot protect and unlock all the rest of the seeht then when you protect the sheet only the locked cells are protected the rest is free.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top