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 42 weeks ago
6 years 28 weeks ago
6 years 40 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 49 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago