How to protect a range

J

Jeff

Hi,

Is there a way to protect a range in a worksheet, without protecting the
entire range?

Thanks for your help
 
M

Marcelo

Hi Jeff,

by default all cells are locked, what you could do it selecte entire ws,
FORMAT | CELL | PROTECTION | uncheck LOCKED

Than select just the range that you are thinking to protect and locked the
cells, protect the ws

HTH
Regards from Brazil - going to the 6th *
Marcelo

"Jeff" escreveu:
 
A

Alex

Hello,

If I protect a range of cell, people won't be able to insert any rows within
the range. I would like to know if there is a way to allow people to insert
row when cells are protected.

Thanks!

Alex
 
D

Dave Peterson

If you're using xl2002 or higher, you can protect the sheet and still allow the
user to insert rows.
 
Top