In working scenario, sometimes we need to make password protected file. In this article I am going to discuss how we can make excel file as password protected. Article categorized into two parts.
1. Protection of Complete file
2. Protection of some selected cells
Protection of Complete File
This is very easy task to make complete excel sheet as password protected. For this
Select your sheet (all column and rows of sheet)
After selection of complete sheet, click on Format Tab (You can also click right hand side) . When you click on Format Tab a window will be appear, now that window select protect sheet.
A Pop-window will appear, now this is time to set your password for unprotect the sheet. Uncheck the both Select locked cell and select unlocked cell. Just provide your desired password and press Ok.