how to hide columns and rows by using password in microsoft excel?
select rows/ columns which you wnt to hide.....
Then goto format menu and choose row/column and choose hide option
Now Select the entire worksheet by pressing ctrl+A
Then, goto tools menu thn protection and choose allow users to edit ranges....
Click on New bottom >> OK
After this, click on protect sheet bottom.
Tick all the options except Format Rows and Format columns. So that other can't unhide the rows or columns
Then give the password to unprotect it
Click on Ok bottom.
Retype the password
Then click on Ok bottom
after than no body can unhide hidden row/colown without passowrd
Thanks
Mirror Glance & Binod Adhikari
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago