Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Over time, a workbook can collect cells that contain hidden information of no use. These cells don't have any data, but still take up space because they contain formatting, blanks, or non-printing characters.

Consequently, too many of these cells can cause your workbook to slow down or become unresponsive. You can use the Check Performance feature to find and remove these cells.  

  1. Select Review> Check Performance.

    Check Performance

  2. The Workbook Performance pane displays the number of cells used in a workbook and how many of them can be optimized. The Optimize all button will clean up all cells in the workbook.

    Workbook Performance

  3. Click to see specific details about optimizable cells on any given sheet. The Optimize sheet button will clean up only the cells for that specific worksheet.

    Cell Performance

Warning: If your workbook contains one or more sheets dedicated to Pixel Art, do not use Optimize Sheet or Optimize All. Cells with Pixel Art will be removed. Excel cannot differentiate between a Pixel Art cell and an unwanted formatted cell with no data.  If you used Optimize Sheet or Optimize All, use Undo to recover these cells. 

Note: You may notice small differences between the number of unwanted formatted cells visible in the grid and the number of cells to optimize identified in the task pane. This is because Check Performance identifies and removes additional internal cell data structures associated with unwanted formatted cells visible in the grid when displaying the cell count.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!