How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1936
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

Hi Andrew, I have another question. How can I protect the

This answer was rated:

Hi Andrew, I have another question. How can I protect the columns in the spreadsheet so that the user can't overtype the formulas, while still leaving columns free to enter data. Same Spreadsheet

The-PC-Guy :

Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question

The-PC-Guy :

can you tell me which version of excel you are using?

Customer:

Hi Andrew, you just helped me with the formula. I was using xlsx but had to downgrade to xls to send to you. prefer to use xlsx

The-PC-Guy :

i mean are you using office 2007

The-PC-Guy :

office 2010

The-PC-Guy :

2013

The-PC-Guy :

ect..

The-PC-Guy :

ive got a better idea

The-PC-Guy :

can I remote into your computer so I can see your screen

The-PC-Guy :

and show you how to do this?

Customer:

I am already remoting in from home to my office pc so not sure how a double will work!

Customer:

im using 2010

The-PC-Guy :

yea, it would not work very well, I don't think, firewall issues asside

The-PC-Guy :

it would be sloppy and confusing

The-PC-Guy :

there are 2 ways to do this

The-PC-Guy :

so

The-PC-Guy :

ok

The-PC-Guy :

one would be to put a password XXXXX the sheet, and lock out certain cells so they could not be modified without typing a password

The-PC-Guy :

1.would be to put a password XXXXX the sheet, and lock out certain cells so they could not be modified without typing a password

The-PC-Guy :

2.

The-PC-Guy :

to use what is called data validation

The-PC-Guy :

that is only allowing certain values to be entered

The-PC-Guy :

or a message would be displayed

Customer:

Would rather just lock those columns without locking sheet

The-PC-Guy :

ok

The-PC-Guy :

when I say lock the sheet

The-PC-Guy :

you can specifiy

The-PC-Guy :

which columns get locked and which dont

The-PC-Guy :

the sheet could still be viewed

The-PC-Guy :

and unlocked cells can be modified

Customer:

ok but don't want a password XXXXX the user to have to enter (happy for me to enter to alter anything in the locked columns)

The-PC-Guy :

but not locked ones

The-PC-Guy :

is the user going to modify any of the locked columns?

Customer:

no

The-PC-Guy :

ok

The-PC-Guy :

then this would work for you

The-PC-Guy :

the user would not need to enter the password XXXXX use the sheet

The-PC-Guy :

the only time the password XXXXX be needed

Customer:

sounds good

The-PC-Guy :

would be for modifications to locked columns

The-PC-Guy :

so

The-PC-Guy :

to do this

The-PC-Guy :

first you have to highlight any columns that you want unlocked

The-PC-Guy :

or modifyable

The-PC-Guy :

by default the whole sheet is locked

The-PC-Guy :

so we need to unlock the editable areas

The-PC-Guy :

are you with me so far?

Customer:

ok

The-PC-Guy :

so once you have a column selected

The-PC-Guy :

you right click in the column somewhere

The-PC-Guy :

and select format cells

The-PC-Guy :

from the menu

Customer:

done

The-PC-Guy :

click the protection taab

Customer:

ok

The-PC-Guy :

and make sure the locked box

The-PC-Guy :

is unchecked

Customer:

done

The-PC-Guy :

do the same for any other rows or columns or even individual cells

The-PC-Guy :

that you want edited

The-PC-Guy :

only the cells/columns you want locked should have that box checked

The-PC-Guy :

now

The-PC-Guy :

you don't have to do all of this right now

The-PC-Guy :

you can just do it for one column so you can see how this works

The-PC-Guy :

then you can do the same procedure for anything else

Customer:

done

The-PC-Guy :

ok

The-PC-Guy :

now

The-PC-Guy :

right click the sheet name

The-PC-Guy :

in the sheets tabs

The-PC-Guy :

at the bottom

The-PC-Guy :

click protect sheet

The-PC-Guy :

in the next window is a whole bunch of options

Customer:

ok

The-PC-Guy :

allows you to set the level of permisions

The-PC-Guy :

for the most secure

Customer:

this is where i got lost last time

The-PC-Guy :

you want to uncheck

The-PC-Guy :

everything accept

The-PC-Guy :

select unlocked cells

The-PC-Guy :

so

Customer:

ok

The-PC-Guy :

of all those check boxes

The-PC-Guy :

only select unlocked

The-PC-Guy :

should be checked

The-PC-Guy :

then in the box above

Customer:

done

The-PC-Guy :

you enter your password

The-PC-Guy :

remember this password

The-PC-Guy :

because once it is applied and the file is saved

The-PC-Guy :

you would not be able to unlock without it

The-PC-Guy :

click ok

The-PC-Guy :

and it will ask you to confirm

Customer:

that works!!! Thanks so much

The-PC-Guy :

ok

The-PC-Guy :

your all set then

The-PC-Guy :

rating is open when you are ready

The-PC-Guy :

thanks

The-PC-Guy and 2 other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions