is there a way to protect a range of cells on a worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to lock several columns in a worksheet that contain formulas that
I do not want to be able to accidentally change. Is there a way to do this,
or can I only protect the entire worksheet?
 
Select the whole worksheet, do format>cells>protection, uncheck locked, now
select the columns you want to protect,
repeat and select locked, protect the sheet
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protect Only Certain Cells 2
Protect/Restrict usage of a range of cells. 2
Cell Protection? 2
AUTOFILTER IN A PROTECTED WORKSHEET 1
insert object worksheet protected 2
Enabling Autofilter and Sorting in a Protected Sheet 2
corrupted formula in protected worksheet 21
How to change format protection default to unlocked? 2

Back
Top