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