Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2010

Pallavi has attended:
Excel Advanced course

Excel

Please first state which Training Course this forum post is about: hi,

I am trying to protect a row in excel workbook. I don't want people editing this row where I have some tick boxes. Is it possible to protect just one row and not the whole sheet?

regards,
Pally

RE: excel

Hi Pally

Thank you for your forum post

You have a few options available.

I would suggest selecting the entire sheet and unlocking the cells. This can be done by right clicking on the selected cells and selecting Format Cells. From there you can select the protection tab and remove the tick from Locked.

Then select the cells you don't want your users to access and repeat the process above with the exception of adding the tick to Locked this time.

You should now be able to protect the sheet as per normal and while they might be able to click on the protected cells, they won't be able to edit them.

Hope this helps

Kind regards
Wendy

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Mon 23 Oct 2017: Automatically marked as resolved.

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.