Ask a new question

How do I lock cells in a teams spreadsheet?

For context, I have created a production reporting spreadsheet for my factory that I have roughly 20 people report on daily.

I need to know how to lock cells with formulas in them so that they don't have the ability to change them, whether it be through misunderstanding , misclick, or malintent.

I have been able to figure out how to lock full pages of the workbook and lock files/folders, but I cant figure out how to lock just some of the cells on a page like can be done in excel.

I have also tried locking the cells in excel and uploading the document with locked cells, but they seem to become unlocked once they enter teams.

any help is appreciated,

thanks.

Hello, I'm Celso, Independent Advisor. Happy to be able to help you today!

Please initially check the link below:
https://support.microsoft.com/en-us/office/lock...

If after checking and still does not solve your problem please contact us again, ok

Have a good day!

Celso

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

If by default it was not possible to solve through the previous link, I suggest you check this video, ok.

https://www.youtube.com/watch?v=vTGeVgzxzAs


Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

This process only works for excel, unless I am missing something.

When editing the files in microsoft teams the small arrow to open the Format Cells popup window does not appear in the alignment group.

highlighting, right clicking, and selecting "format cells" also does not work because the option to open the format menu does not exist on teams as it does in excel.

21 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Other considerations:

https://support.microsoft.com/en-gb/office/lock...

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated May 10, 2024 Views 6,319 Applies to: