locking/protecting rows?

  • Thread starter Thread starter erocks5
  • Start date Start date
E

erocks5

Is there a way to lock or protect certain rows or columns withou
protecting the whole sheet? Thanks for any help in advance!
 
Rocks,

You can unprotect all the other cells (Format - Cells - Protection -
Locked), then protect the workbook (Tools - Protection - Protect worksheet.
With Excel 2002 (and maybe 2000, but not XL 97), you have additional choices
as to what the user can and can't do).
 
Yes.
Before you protect your sheet, you must first determine what cells you want
unlocked.
To unlock a cell Right-click the cell, then select Format Cells. Go to the
Protection tab and uncheck "Locked". Then go and set your protection.
 

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

Using Autofilter on a Protected Sheet 18
unable to add row to Excel 2007 TABLE 3
Inserting rows into sheet that contains a formula 2
Protect locked cells (only) from formatting? 4
Excel Cell Protection not Working 3
Locked Cells 3
Lock Cells with Hyperlink 3
protecting cell depending on value of another cell 1

Back
Top