Protecting Workbooks and Worksheets in Excel

No video

Protecting Workbooks and Worksheets in Excel

Рет қаралды 21,061

Simon Sez IT

Күн бұрын

Пікірлер: 13

@steveselby6817 Жыл бұрын

Great Video, very clear and concise explanation , thank you

@seamusmadden4705 10 ай бұрын

Excellent clear explanation - thank you

@SimonSezIT 10 ай бұрын

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

@aradhyarathi2048 3 жыл бұрын

Thank you for this!!

@SimonSezIT 3 жыл бұрын

No problem 😊

@geoguy29 9 ай бұрын

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?

@TimHPop776 2 жыл бұрын

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?

@SimonSezIT 2 жыл бұрын

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.