For Microsoft Windows users who need to remove security provisions from an Excel file, follow these steps: Open Excel on your computer. Select the Excel file you want to unprotect.

Click "Close" to close the Find and Replace window, but do not click anywhere else to keep the cells selected. Press "Delete" to delete all unprotected cells in the Excel 2010 spreadsheet.

I can open the .xlsx file, I can't do anything to the worksheet other than enter data. Heck, I can't even change the font. I did try saving it as an .xls file, but no dice.

Removing hidden metadata information from a Microsoft Excel spreadsheet is not difficult if you follow the steps laid out here.

Blank rows can find their way into your worksheets through various means—but no matter how they get there, it’s a good idea to get rid of them. This ebook ...

Page breaks help in classifying & organizing your work in Microsoft Excel. Here is a guide that shows you how to insert, move, delete Page Breaks.