Great Video, very clear and concise explanation , thank you
@seamusmadden470510 ай бұрын
Excellent clear explanation - thank you
@SimonSezIT10 ай бұрын
Thank you so much for your kind words! I'm glad you found the explanation clear and helpful. 😊 We have additional free Excel training if you need it 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support! #SimonSezIT #Excel
@aradhyarathi20483 жыл бұрын
Thank you for this!!
@SimonSezIT3 жыл бұрын
No problem 😊
@geoguy299 ай бұрын
What if I want others to view but restrict entire workbook any kind of changes/edits?
@wallybandaqumayo6536 Жыл бұрын
I have a question about Encrypting the workbook with a password. Scenario is that I've set the password, shared the file with one person, then instead of removing the current password, I choose to update the password. Will the password change affect the person who has the old password?
@rohit1211 Жыл бұрын
Can i simply encrypt only worksheet?
@TimHPop7762 жыл бұрын
Hello, I would like to protect the workbook, but I want to leave a row of boxes for the client to clink on to pick options to upgrade if they would like. How do I do that?
@SimonSezIT2 жыл бұрын
You need to uncheck the Locked box of those cells that you want to leave editable. It should be under Protection in the Format Cells option
@eslamfahmy87 Жыл бұрын
What about if I need to hide all formula at all worksheets and give allow for input data. I need to activate this order for all worksheets I have it . I tried by kuttools but not work good
@SimonSezIT Жыл бұрын
You can try this: 1. Select the range of cells or columns that you want to allow for editing/data input 2. Right-click and select Format Cells 3. Go to the Protection tab and uncheck "Locked" 4. Enable Protect Sheet This step will leave the selected range "unprotected" or unlocked.
@eslamfahmy87 Жыл бұрын
@@SimonSezIT thanks alot what about if I need to make this process on more than spreadsheets at one time not onr by one.