Workbooks in Microsoft Excel can be a time-consuming process to optimize for the web. By following these tips, you can make your workbooks faster and easier to use.

  1. Use the same worksheet for all your data. When you have data from different sources on different worksheets, it can slow down your workbook. Consolidate all your data onto one sheet and then use formulas to merge the data into one column or row.
  2. Use macros to speed up your workbook. Macros are small pieces of code that you can insert into your workbook to automate tasks or save time. For example, you could use a macro to automatically fill in values from a text box with the correct values from a table or database.
  3. Use charts and graphs sparingly. Charts and graphs can take up a lot of space on a page, which can slow down your workbook’s performance. Try to limit the use of charts and graphs to cases where they really help illustrate your data points clearly.
  4. Minimize the number of sheets in your workbook. When you have multiple sheets in your workbook, Excel needs to calculate each sheet’s calculations separately before it can display them onscreen together as one document - this process is called “sheet calculation.” If you have too many sheets in your workbook, this process will take longer and affect overall performance of the workbook.. ..

When you use Excel on the web, do you notice that your workbook takes a long time to load? Microsoft seeks to help you solve this problem with Check Performance. Here’s how it works.

With Check Performance, you can see empty cells in your workbook that contain formatting, whether visible or not. You might have had data in these cells at one time. Even though that data is now gone, the formatting remains and adds to the size of the workbook. This can cause a slowdown in performance.

Check the Performance of an Excel Workbook

Visit Excel on the web, sign in, and open the workbook you want to review. You may see a message in yellow at the top encouraging you to try out the feature by providing a link. But you can 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.

At the top of the sidebar, you’ll see how many cells are used and the number of cells to optimize in the workbook.

You’ll then see a list of the sheets containing empty cells that can be optimized. Hover your cursor over the information icon (small letter “i”) next to Review by Sheet to see the total.

You can then select each sheet to view the cells if you like. You’ll see which cells can be optimized using the cell reference(s). You’ll also see the type of formatting to remove in the cell, including things like number formatting, text properties, and fill color.

Click the cell or cell range in the box to highlight those cells in the sheet if you want to review them.

Optimize the Cells in a Workbook

You have a few ways to optimize the sheets and cells you see in the sidebar. Microsoft allows you to control how you remove the formatting (if you want to).

RELATED: How to Clear Formatting in Microsoft Excel

Optimize the Workbook

If you want to optimize the entire workbook in one fell swoop, this is the simplest option. With the Workbook Performance sidebar open, click “Optimize All” at the bottom.

Optimize the Sheet

If you prefer to review each sheet and optimize them one at a time, this is another option. 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 to manually remove the formatting from the empty cells. Start by selecting a sheet in the Workbook Performance sidebar. Then, click the cell reference or range in the box to highlight the cell(s) in the sheet.

RELATED: How to Remove Table Formatting in Microsoft Excel

Since you can see the formatting that’s contributing to how the workbook performs, you can then remove that formatting from the cell(s) yourself if you want.

An easy way to do this, especially if the cell(s) contains several formatting types, is to go to the Home tab and select the three dots on the right side of the ribbon for More Options. Move your cursor to Clear in the Editing section and pick “Clear Formats.”

You can, of course, use your own method to remove the formatting if you prefer.

As you optimize the workbook, sheets, or cells and make changes to your workbook, the Workbook Performance tool updates. So, you may see a message in the sidebar to recheck the workbook. Click “Check Again” to run 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. Being able to see what improvements you can make to optimize the workbook is a handy feature to keep in mind.

Be on the lookout for this Check Performance feature to arrive in Excel for Windows and Mac in the future.