poke the big “Optimize All” button to apply all the suggested optimizations to your entire workbook.
Microsoft seeks to help you solve this problem withCheck Performance.
Here’s how it works.
You might have had data in these cells at one time.
Even though that data is now gone, the formatting remains andadds to the sizeof the workbook.
This can cause a slowdown in performance.
But it’s possible for you to access it manually too.
Go to the Review tab and select “Check Performance” in the ribbon.
This opens the Workbook Performance sidebar on the right.
You’ll then see a list of the sheets containing empty cells that can be optimized.
you might then select each sheet to view the cells if you like.
You’ll see which cells can be optimized using the cell reference(s).
Microsoft allows you to control how youremove the formatting(if you want to).
With the Workbook Performance sidebar open, click “Optimize All” at the bottom.
Select a sheet from the list in the Workbook Performance sidebar.
Then, click “Optimize Sheet” at the bottom.
Manually Change the Cells
One final option is tomanually remove the formattingfrom the empty cells.
Start by selecting a sheet in the Workbook Performance sidebar.
Move your cursor to Clear in the Editing section and pick “Clear Formats.”
So, you may see a message in the sidebar to recheck the workbook.
Click “Check Again” to execute the performance test after you make changes.
When the file size of your workbook grows over time, it can take longer to load in Excel.
Be on the lookout for thisCheck Performance featureto arrive in Excel for Windows and Mac in the future.
