Protection

adavies

Board Regular
Joined
Nov 15, 2005
Messages
61
How do I protect a range of cells to make it read only?

I've been using the protection option on the menu, but it always protects the whole sheet?
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,759
Office Version
  1. 365
Platform
  1. Windows
Hi Adisorn

Select your range, from the top toolbar go to format / cells / protection and select "locked." then protect the sheet.

You'll have to unlock all of the other cells on the sheet that you want to keep read/write though, of course you just use the same method, select them all at once but "Unlock" them.
 

adavies

Board Regular
Joined
Nov 15, 2005
Messages
61
tHANK yOU

Thanks,

I'm a little backwards tonight... that's what I was doing, but I was locking the wrong cells.... :eek:ops!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,234
Messages
5,571,045
Members
412,359
Latest member
misstoffeepenny
Top