Excel has useful features for developing forms and hiding information so that it’s easy to create mini apps which take user entered information, combine with data stored in the spreadsheet and provide an answer. Some of the spreadsheets are very sophisticated and Excel offers a “protect” feature that locks down a sheet (or workbooks) and prevents unwanted meddling or fiddling with the data. The protect feature even lets the owner set a password so that the more determined meddler can be thwarted and confidential data kept confidential.

1- Go to file menu click option (This step if developer menu not available). (Delete remove password from excel )

remove password excel


2-Go to customize ribbon, on the right side tick mark developer.(remove password from excel )


remove password excel


3- Go to main menu select developer then click visual basic. ( Delete remove password from excel )

remove password excel

4-Double click in your sheet the dialog box will open at right side then paste the code (available end of this post) and close the visual basic only not excel sheet.

remove password excel


5-Go to main menu select developer then click Macros

remove password excel



6-Select Macros then click Run

remove password excel

7-Click NO .

remove password excel

8-Now click ok and enjoy please share this post and put your comment .

remove password excel

For more details see this video



Copy this code to excel sheet