how to hide columns and rows by using password in microsoft excel?

mirror glance's picture

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