How to Hide and Lock Columns in Excel скачать в хорошем качестве

How to Hide and Lock Columns in Excel

How to Hide and Lock Columns in Excel In this intermediate excel tutorial I’ll explain how you can quickly hide confidential data in excel. We are going to hide data from an entire column and then lock the worksheet so that no one can see or edit that column. This is not a typical approach where you select the cell and hide it. If you follow the traditional way to hide columns in excel everybody will know that you have hidden a column. But here we’ll not hide the column, instead we’ll hide the data from entire column and then lock it. So that know one will even know that there were data, making it safe and secure. Now I’m sure you know a lot about locking cells in excel. Let’s follow the procedure below to learn how to lock and hide columns in Excel. Step 1: Select the entire column that you need to hide and lock Step 2: Right-click and click on format cells. Step 3: Click on Custom and now remove General and write three semicolons. ;;; Step 4: Click on and done. Cell values are now partially hidden Step 5: Select the entire worksheet by pressing CTRL+A. Step 6: Right-click and select format cell. Step 7: Select protection and make sure locked and Hidden checkboxes are unmarked. Step 8: Select the Cell or Range of the cells that you need to hide and lock. Step 9: Right-click and click on format cells. Step 10: Select protection and make sure locked and Hidden checkboxes are marked. Step 11: Click on the review tab and click on Protect Sheet Step 12: Enter Password twice and done Now your selected column is hidden and locked. #Lock #Hide #Column Thanks for watching. ---------------------------------------------------------------------------------------- Support the channel with as low as $5   / excel10tutorial   ---------------------------------------------------------------------------------------- Please subscribe to #excel10tutorial https://goo.gl/uL8fqQ Here goes the most recent video of the channel: https://bit.ly/2UngIwS Playlists: Excel Tutorial for Beginners: https://goo.gl/UDrDcA Intermediate Excel Tutorial: https://tinyurl.com/59a837py Advance Excel Tutorial: https://goo.gl/ExYy7v Excel Text Case Conversion Techniques: https://goo.gl/xiP3tv Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB All About Comments in Excel: https://bit.ly/excelcomments Excel VBA Programming Course: http://bit.ly/excelvbacourse ChatGPT Excel Mastermind: https://tinyurl.com/46kn7tmd Social media: Facebook:   / excel10tutorial   Twitter:   / excel10tutorial   Blogger: https://excel10tutorial.blogspot.com Tumblr:   / excel10tutorial   Instagram:   / excel_10_tutorial   Hubpages: https://hubpages.com/@excel10tutorial Quora: https://bit.ly/3bxB8JG Website: https://msexceltutorial.com/ Become a member and enjoy exclusive perks while supporting the channel you love!    / @excel10tutorial