If you don't have access to the password, you can click on the "Preview" option to open the password-protected MS Office file ...

Microsoft Excel has been one of the go-to spreadsheet apps for several decades, and it's developed an array of tricks throughout its lifetime, not just for making data entry, editing, and organization ...