Hi,
Can u guys please tell me how to restrict users from changing the font, format of the cells that are allowed to write on.
Thank you.
Hi,
Can u guys please tell me how to restrict users from changing the font, format of the cells that are allowed to write on.
Thank you.
Hi Statue.919- If you password-protect the sheet, you can restrict such changes. Go to Review ribbon and select Protect Sheet. It's pretty simple, just follow the instructions.
(To unlock cells where text will be entered, right-click on them, select Format Cells..., select the Protection Tab, and un-check the Locked checkbox.
Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee
Last edited by leelnich; 05-28-2017 at 01:44 AM.
Thank u for your reply.
I have protected that way but when i copy something from another sheet to this sheet the font and format changes.
I want a solution for this.
Thanks in advance.
Withdrawn-LLN
Last edited by leelnich; 05-28-2017 at 09:06 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks