Lock format but allow data entry

I

Iriemon

Is there any way to lock the format of a cell but allow users to input data?

I have a worksheet that has specific formatting in certain cells (background
color, borders, fonts, # of decimals displayed,etc) but users need to be able
to input data into the cells. I would like to prevent users from copying and
pasting into the cells which would also potentially change the format.

Thanks

Irie!
 

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

Locking a format 1
How do you lock a cell with data but still allow new data entry? 1
David Biddulph is correct 8
Excel Can you lock the value of a cell but not the format? 1
Any way to Lock format but not the values? 8
Excel 95 (sorry) 7
How 2 lock row and column delete/add but allow data entry? 7
locking page layout but allowing data entry 1

Top