excel
RH

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Urgent Priority · Version 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:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips


Server loaded in 0.05 secs.