0:55 Hiding rows,columns and sheets 2:25 Protect workbook 3:34 Protect a whole spreadhsheet making it read-only 3:58 How to allow changes on read-only sheets 4:28 How to allows user input trough a dropdown bar (enforces data integrity) 5:54 Protect and unprotect a cell on a protected sheet 7:22 Make a document read-only 7:30 Encrypt the document with a password Little recap of the video:)
wow i really like tour videos. i am learning a lot at home, i have never did computer lesson but through you, you made my life soo easier thank you. All the way from Namibia
Great video! Is there any backend benefit/enhanced security by preventing any editing for the entire workbook upon initial entry (file -> passwords -> prevent editing = making it read-only) vs protecting/"locking" all sheets/ workbook from within the file itself (Review Tab -> Protect Workbook/Protect Sheet)? Other than differences in read-only versus locking from a frontend accessibility standpoint (still can unhide arrays in read-only for example), is it more advantageous to use both forms/"layering" of security, or will the locking-features from within a file be enough?
How do you make it read only (WITHOUT the "edit anyway" button) but users can save their own copy that they can enter values in? I have a sheet that everyone fills in their own data, but I don't want the master template messed with.
Thanks for the Video, I would like to know if you have a worksheet where several parties have to input data, but each must not be able to see the other's input. Is there a way to do this
I got "promoted" to take care of MTBF in my company and that helps a lot - thank you! What if all options like view only are unavailable? Nobody else is on this workbook while trying to make a change so IDK why I can't pick anything from the Info page/protect. I have the password but maybe it's because I'm not an author of this file?
Videos are really great. I would like to know in a single dashboard how to create a different view. To illustrate when employees click it should show one specific sheets others should sheet be automatically hidden. When managers click the excel all the sheets should be viewed how to do this??
Hello, thank you for info. Very helpful. I have a questions about protecting sheets and hiding columns. I can’t seem to sort or filter once I do those functions. Any advice?
I found your channel for the RUclips search bar. I did learn quite a bit today. I am after a very specific protection setup. I have a 2 page proposal for insulation clients. I want to protect all of page 1, and on page 2; but as part of page 2 I want to leave a row of boxes for the client to click in to pick out options to insulate different scopes in their custom homes. Your assistance please. Thank you.
Thank you for this video, I was wondering what if I have a workbook with multiple sheets ' taps ' and I want to select all sheets to delete something but I want a single sheet 'tap' to be protected to it can't be deleted but I can also deleted the other data in the other sheets, can you help me please
Nice I jusy want to is there anyway to protect the sheet or to unable editing of the whole file.. Thanks buddy for making this easy for us to learn. I would like to call you Sir.
Thank you for this video. I found this by searching google. Quick question, I created a workbook with a dashboard with pivot tables. I want the user to be able to look at the various data but don’t want them to be able to change any of my data. How can I do that? I’ve already hidden my data sheet. Thank you in advance.
How can I protect the 1st page of the sheet while editing the format of the other sheet? Like for example, I want to change the column sizes of the 2nd sheet but It always affects the 1st page.
If I make my workbook Read Only but still want people to use it just not change the master copy, would they just need to select Save as and then fill in the unprotected cells?
I have a colleague that needs to lock cells and protect sheet but when she does it stops her using a hyperlink? she needs to put this into a document that people can hit the link and be able go to fill in certain open cells. How do you keep hyperlink available when you protect a sheet? Or is she doing something incorrectly that the hyperlink is greyed out?
What if I want to make an entire workbook edit only but would still like a limited few people to have password access to view. But only have to enter the password in a box that pops up when they try to edit.
How do you lock all columns and tabs with the exception of the last one so when over hundreds if not 1000s people fill-in the sheet they don't modify or alter any information from the person previous to them? I want them to be able to see the fill info but can only input their info only.
I understand how to give editable access to a column but is there a way for the owner of the document to always have editable access to everything without having to click protect and unprotect everytime they want to make a change to the locked columns?
How can I do a read only, but have multiple people use a password to edit at one time? When I put a password, only 1 person can edit. We have a team of people editing and a team of people viewing.
Clear helpful instructions, still relevant in 2024. Thanks!
Thanks so much, this was super easy to follow and implement, You saved me from much headaches at work lol Thanks again and keep up the great work!
0:55 Hiding rows,columns and sheets
2:25 Protect workbook
3:34 Protect a whole spreadhsheet making it read-only
3:58 How to allow changes on read-only sheets
4:28 How to allows user input trough a dropdown bar (enforces data integrity)
5:54 Protect and unprotect a cell on a protected sheet
7:22 Make a document read-only
7:30 Encrypt the document with a password
Little recap of the video:)
Simple ...Simple....Simple...Simple.... Keep doing your videos
wow i really like tour videos. i am learning a lot at home, i have never did computer lesson but through you, you made my life soo easier thank you. All the way from Namibia
fantastic overview! thank you! exactly what i was looking for!
Thanks man u helped alot!!! apparently working and studying excel is totally different and im trying to learn more
Glad it helped!
This is wonderful. I felt like a loser when I didn’t know all these. But thanks to you.
Thank you. You taught me how to protect my workbook,
Really useful advice! Thanks!
Well done. No nonsense. Thank you.
Great!
Very useful. Thank you!
Glad it was helpful!
Thanks a the lesson.
I would like to know how I can protect my Excel file so as not to allow people from reselling it.
So helpful, thank you!
clear instructions, easy to follow, Great!!!
Thanks!!
Great one, I’ve really grabbed alot
Great video! Is there any backend benefit/enhanced security by preventing any editing for the entire workbook upon initial entry (file -> passwords -> prevent editing = making it read-only) vs protecting/"locking" all sheets/ workbook from within the file itself (Review Tab -> Protect Workbook/Protect Sheet)?
Other than differences in read-only versus locking from a frontend accessibility standpoint (still can unhide arrays in read-only for example), is it more advantageous to use both forms/"layering" of security, or will the locking-features from within a file be enough?
Very useful. Thanks.
Awesome
Very helpful 😊
very usefull! Thank you.
Very helpful and easy to follow. Thank you!
Great video. Can you discuss Protect Structure &. all the other Protect Workbook options in the Backstage view?
super helpful, thanks!
Thank You. This help me out so much :)
Thank you. Great info!
great information
Google search=problems solved. Thank you!
its really helpful
Nice! Thank you for all the information
thanks, nice work
Very Good. But I Still Haven't Found a video with the sheet protect and at the same time with the possibilty to refresh a pivot table
How do you make it read only (WITHOUT the "edit anyway" button) but users can save their own copy that they can enter values in? I have a sheet that everyone fills in their own data, but I don't want the master template messed with.
THIS
The way I do this is: 1. Unlock the template 2. Make a copy of the document 3. Lock the template again
Thanks for video!
Could you please show us how to program VBA allowing automatically expand table in PROTECTED SHEET !
Great! Is there a way to allow user to change only tha lines that they create by themself?
it was useful
Well done! Thanks
Subscribed. Great video.
Thanks for the Video, I would like to know if you have a worksheet where several parties have to input data, but each must not be able to see the other's input. Is there a way to do this
I got "promoted" to take care of MTBF in my company and that helps a lot - thank you!
What if all options like view only are unavailable? Nobody else is on this workbook while trying to make a change so IDK why I can't pick anything from the Info page/protect. I have the password but maybe it's because I'm not an author of this file?
Videos are really great. I would like to know in a single dashboard how to create a different view. To illustrate when employees click it should show one specific sheets others should sheet be automatically hidden. When managers click the excel all the sheets should be viewed how to do this??
Any tips on how to avoid the zip to xml hack?
Thanks.. but i thought you have mentioned anything about locking columns to delete
Very Good
Hello, thank you for info. Very helpful. I have a questions about protecting sheets and hiding columns. I can’t seem to sort or filter once I do those functions. Any advice?
Really useful bro I linked you
I found your channel for the RUclips search bar. I did learn quite a bit today.
I am after a very specific protection setup. I have a 2 page proposal for insulation clients. I want to protect all of page 1, and on page 2; but as part of page 2 I want to leave a row of boxes for the client to click in to pick out options to insulate different scopes in their custom homes. Your assistance please. Thank you.
Thank you for this video, I was wondering what if I have a workbook with multiple sheets ' taps ' and I want to select all sheets to delete something but I want a single sheet 'tap' to be protected to it can't be deleted but I can also deleted the other data in the other sheets, can you help me please
Nice I jusy want to is there anyway to protect the sheet or to unable editing of the whole file.. Thanks buddy for making this easy for us to learn.
I would like to call you Sir.
Would love to learn how to protect a worksheet AND ALLOW SPELL CHECK in the cells that are unlocked.
Thank you for this video. I found this by searching google. Quick question, I created a workbook with a dashboard with pivot tables. I want the user to be able to look at the various data but don’t want them to be able to change any of my data. How can I do that? I’ve already hidden my data sheet. Thank you in advance.
How do you restrict others from making adjustments while the sheet is open from someone else? Trying to prevent multicable copies of the same sheet.
How can I protect the 1st page of the sheet while editing the format of the other sheet? Like for example, I want to change the column sizes of the 2nd sheet but It always affects the 1st page.
If I make my workbook Read Only but still want people to use it just not change the master copy, would they just need to select Save as and then fill in the unprotected cells?
HI..... I want may excel to Unable to Delete/ Edit and able to Copy and Past but should be still protected
I have a colleague that needs to lock cells and protect sheet but when she does it stops her using a hyperlink? she needs to put this into a document that people can hit the link and be able go to fill in certain open cells. How do you keep hyperlink available when you protect a sheet? Or is she doing something incorrectly that the hyperlink is greyed out?
Is there a way that I can prevent people to send the document via email, message, etc? Like asking for another password or something like that?
What about kuttools plus if I need to locked a formula if many of worksheets at workbook
What if I want to make an entire workbook edit only but would still like a limited few people to have password access to view. But only have to enter the password in a box that pops up when they try to edit.
Is it possible to enable macros for a user of the file but keep it protected from editing cells?
How do you lock all columns and tabs with the exception of the last one so when over hundreds if not 1000s people fill-in the sheet they don't modify or alter any information from the person previous to them? I want them to be able to see the fill info but can only input their info only.
Found you sheet searching Protecting Sheets
Thanks for commenting
How to prevent someone to copy and save the file
I understand how to give editable access to a column but is there a way for the owner of the document to always have editable access to everything without having to click protect and unprotect everytime they want to make a change to the locked columns?
Let me know if you found a way to do this please
I did a search of RUclips!
Awesome
How can I do a read only, but have multiple people use a password to edit at one time? When I put a password, only 1 person can edit. We have a team of people editing and a team of people viewing.
How to protect multiple sheets within seconds
Do you purposely zoom out when you're trying to teach crucial areas?
I zoom out to show me switching between tabs
🇵🇱
I was expecting something advanced... This just covers the very very very basics. So not helpfull at all.
Good to know 😜
only waste of time
Sorry!
please speak slowly
can i get your email?