Hide and lock a column in Excel, hide a column without locking the rest of the sheet, hide formulas. Hiding and locking formulas allows you to protect formulas and information.
Check out my online courses
For more help visit my website or email me at easyexcelanswers@gmail.com.
Contact me regarding customizing this template for your needs.
Click for online Excel Consulting
I am able to provide online help on your computer at a reasonable rate.
Check out my next one-hour Excel Webinar
I use a Blue condensor Microphone to record my videos, here is the link
Check out Crowdcast for creating your webinars
If you need to buy Office 2019 follow
I use Tube Buddy to help promote my videos
Check them out
Follow me on Facebook
TWEET THIS VIDEO
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I’ve used or have experience with.
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
hi good day. its worked but i can't apply filter. can you advice ? thanks in advance
but if someone copy the hidden/locked columns and paste somewhere else in some other sheet, and then unhide…it shows all the contents
Great content, exactly what I needed
Why go to another copy at @1:47? What does that do for the sheet we have been working on? Now i have to go and undo what you just showed to make a copy.
Thanks, very helpful!
Thanks ma'am. That's superb
Thanks you for tutorial
nice.. its solved my problem
i need to know how to hide single cell in excel which i dont need n my text
Thank you so much!!! this helps me alot.
thank you for helping… 🙂
Excellent tutorial!!!!
Thank you very much
Thanks a lotttttttttt
Thanks
Thank you!
This is perfect – exactly what I needed to know. I needed to hide specific columns and password protect while leaving rest of sheet editable. Great clear explanation. thank you!