Excel will then highlight all of the blank ... go to the Home tab and find the "Delete" button on the right-hand side. Select "Delete Sheet Rows." This will remove the blank rows.

The Inquire tab should now be visible in the ribbon. To remove the excess formatting from your current Excel file, go to the Inquire tab and choose the Clean Excess Cell Formatting option.

The company has also made it easy to remove those protections. Here's how to unprotect a Microsoft Excel worksheet. Read more: Major PC Brands Ranked Worst To Best For the purposes of this article ...