Protecting a block in a cell

R

Rosa

I don't want to protect an entire cell, but part of it. Example: Iwant to be
able to protect cells F28-F39 and not protect Cells F1-F27. How can I do
that!
 
D

David Biddulph

By default the cells will be locked if you protect the sheet. Select cells
F1-F27, Format/ Cells/ Protection, & unselect "Locked". Then protect the
sheet.
 

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

Protecting Word 2019 document 0
sqlite-odbc write conflict 2
Excel does not accept text format! 0
write-protect 1
best way protect unprotected cells 2
Override protected sheet message? 4
Returned position address on protected sheet 7
Cell Protection 1

Top