2. Select "Go to Special." 4. Excel will then highlight all of the blank cells. Before you delete the blank cells, ensure that only the cells that you want to remove are highlighted. If you just ...

To remove the excess formatting from your current Excel file, go to the Inquire tab and choose the Clean Excess Cell Formatting option. Once excess formatting is removed, click Yes to save changes ...