If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what topics you want me to cover in future videos.
@trumpexcel
4 жыл бұрын
Thanks for commenting Natalia... One way to do this could be to disable editing directly in cell. Click the File tab, click on Option and then Advanced. In the options that show up, uncheck the 'Allow Editing directly in cell'. This would stop the prompt to show up. However, if you now need to edit cells that are not protected, you will have to do it through formula bar only.
@kamalgoyal4638
3 жыл бұрын
👍
@joea2r
2 жыл бұрын
Can you disable the popup message "The cell or chart you're trying to change is on a protected sheet..."?
@Jason-Woolf
Жыл бұрын
Excellent - clear and to the point - with a few bonus tips as well - great video!
@justineabundo8586
2 жыл бұрын
Thank you very much for this video! I’ve been watching many videos but this one is what I’m looking for!!! Helped me a lot with my file!!!
@LearningHome-trainings
4 жыл бұрын
Another interesting content from Sumit. Please keep the great job going.
@trumpexcel
4 жыл бұрын
Thanks for commenting... Glad you liked the video!
@Ali-uz8qg
2 жыл бұрын
Thanks. I learned today how to unlock colored cells.
@Thomas-ic6cd
Жыл бұрын
Very nicely and easy to understand. Thank you
@BounceEV
Жыл бұрын
Great video, looks so simple. After protecting the sheet, what happens when the format cells is not available to select...?
@MareeTeolanafo
4 жыл бұрын
Well presented as always and easy to follow; I look forward to more informative videos.
@trumpexcel
4 жыл бұрын
Glad you found it useful Maree!
@sbeku
4 жыл бұрын
You are excellent
@trumpexcel
4 жыл бұрын
You're awesome too :)
@laniefigueroa5193
2 жыл бұрын
Very helpful and easy to follow presentation. Thank you very much!
@timbabitelor
4 жыл бұрын
Thank you Sumit, I just learned now that Ctr+H can select colours. I see those buttons all the time but never thought of exploring it!
@a.rakeshpatro
4 жыл бұрын
wow...thanks for this video
@trumpexcel
4 жыл бұрын
Thanks for commenting... Glad you found the video useful!
@prachigharat6001
4 жыл бұрын
Thank you for the video! Such a life saver!!!
@IvanCortinas_ES
4 жыл бұрын
A great explanation. Thank you Sumit!
@trumpexcel
4 жыл бұрын
Glad you found it useful Ivan!
@vijendermogili5009
3 жыл бұрын
Short and Simple. Thank you
@SAM21358
Жыл бұрын
Thank you.
@mohamedtarek2833
2 жыл бұрын
thank you it's working good
@marianagomez5189
2 жыл бұрын
wooow you saved my projecttt, thank you so much for your videoooo
@keizy1479
2 жыл бұрын
Thank u very much sir
@subhodeepsengupta7171
4 жыл бұрын
I am a great fan of your videos, got inspired and started to educate people about the importance of Excel in the current market. Waiting for more of your videos. Do share your views on the same. Thanks, Subhodeep Sengupta
@trumpexcel
4 жыл бұрын
Thanks for commenting Subhodeep... Glad you're finding the videos useful!
@ams7733
3 жыл бұрын
Thank you very much - this was useful and straight to the point.
@wayneedmondson1065
3 жыл бұрын
Thanks Sumit! Nice tips :)) Thumbs up!!
@sahibzaman1393
2 жыл бұрын
Thanks sir its very useful for me
@taofeekajibade
3 жыл бұрын
Brilliant. Thank you very much.
@ashwathtashu
2 жыл бұрын
Very useful video, Tq so much 😍👍
@jeremygreer476
2 жыл бұрын
Thank you!
@real_shortreels
3 жыл бұрын
Is there any way to add a filter in a protected file, which already has unlocked heading?
@teresachang1026
Жыл бұрын
Thank you for the video. I am using Excel 365. After I clicked on Protect sheet, the Format Cell feature is grey out. I was not able to unlock the specific cell I prefer to keep unlocked. Which version of Excel you were using on this video?
@johnybravo8262
2 жыл бұрын
Thank you so much, it worked po.
@teijarosen2961
3 жыл бұрын
Excellent!
@thama4691
4 жыл бұрын
Seriously.. this is what I need
@SudeshSivenarain-sf8ph
6 ай бұрын
Hi there Sumit, is it possible to lock a specific range of cells in excel which has data using a macro, say 2 columns and 20 rows. In addition, I would like a user to be able to access the rest of the worksheet, hence a macro is also required for the unlock cell command.The above is required for multiple sheets, thus I would like to have this automated on a tab. I have been struggling with this. Kindly assist with a vba code.
@sweetyreddy8033
3 жыл бұрын
Can we lock values in table in the sheet and also get the table expanded?
@ajaykumargupta8504
4 жыл бұрын
Very nice 👍
@barath3956
4 жыл бұрын
Bro Iam Preparing for competitive exams so I get 3-4 hours in a day to learn something so I have the idea to learn excel to get part-time jobs.sir so please tell me is it useful to learn excel in which way I should learn from your videos please suggest me sir. Hope ypu will reply to the comment. thankyou!!
@trumpexcel
4 жыл бұрын
It would definitely help to know MS Excel as there are a lot of part-time jobs if you know Excel. I recommend start here with this FREE Excel course - trumpexcel.com/learn-excel/
@barath3956
4 жыл бұрын
Could you please help me to find some part-time jobs in ms Excel bro. Please suggest any website to search for the jobs bro please
@produratip6198
2 жыл бұрын
Powerful
@rachelcorcoro5538
2 жыл бұрын
Hello hope you could help me with my concern, if I choose on the dropdown list then the template will be enabled, however the columns that were not needed will be disabled. Do you know how?
@mohammedfarook5376
7 ай бұрын
sir Super
@bol3iz
3 жыл бұрын
I'm using a Macbook. Unfortunately, the protection tab doesn't show when I format the specific cells. Any tips?
@shailajareddy2662
4 жыл бұрын
Hi Sumit, Do you also teach Java?
@trumpexcel
4 жыл бұрын
Hello Shailaja.. I only focus on MS Excel :)
@shailajareddy2662
4 жыл бұрын
@@trumpexcel thank you 😊
@sabkuchhlearn
4 жыл бұрын
Hi Shailaja, you can check the Java interview questions: kzitem.info/news/bejne/0HudrHWmj4Zhlqg
@jaeon41
2 жыл бұрын
I don't have the Protection button in the Format Cells menu, but the sheet is protected. Would you know why is that?
@llalbwansingh9362
Жыл бұрын
I have problem with Excel Workbook Password Removal or Recovery to Open. Not excel Sheet password...! Can you help ...?
@brentcosta3705
4 жыл бұрын
Do you offer consulting services?
@pawanpratap6095
Жыл бұрын
I am unable to unzip the protected excel file showing some error
@chiranjeevicm8974
4 жыл бұрын
Hi Mr.sumit...Can we get Microsoft certification for excel and VBA... These may strengthen our resume
@trumpexcel
4 жыл бұрын
Thanks for commenting Chiranjeevi... I do have paid courses that also offer a completion certificate. You can check these here - trumpexcel.com/excel-training And if you're looking for free training, check this - trumpexcel.com/learn-excel
@keenagers5032
2 жыл бұрын
I have watched 2 of your videos and I am not getting it. I have ruined by spreadsheet and now i don’t know what to do
@cristinaponce112
3 жыл бұрын
How can I do this on Google Sheets?
@thegreatinterpreter8382
2 жыл бұрын
Am I crazy? I protect my worksheet and am still able to delete any one of my cells.
Пікірлер: 64