Protection is working sparadically

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

Guest

Running into a strange deal with my Excel...I've protected and saved my sheet
the protection seems to work for the most part as far as formatting is
concerned - as I can't change any formatting. However, when I attempt to
change data it won't let me for the first three or so cells I try and then it
gives in and lets me change all of the data I want to yet not the
formatting....any thought?
 
The cells you can change are not locked. Sheet protection is a two-step
process. First, using Format;cells;Protection tab, unlock all the cells that
you want to be able to enter data into and lock all the cells that you don't
want to enter into. Then 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

Excel Protection 2
Excel Move or Copy Stopped Working? 0
protect cell format 1
Sheet Protection 3
How to change format protection default to unlocked? 2
Format cells dialog 3
Password Protect so can't save and change 1
HDMI is a terrible format and I wish it never existed 2

Back
Top