Excel 2024: Check Performance in Excel

January 9, 2025 - by Bill Jelen

A new feature debuted in 2023. Go to the Review tab and choose Check Performance. If you have a workbook that you've been using for years, you should check performance. It looks for excess formatting, unused cell styles, unneeded metadata that can slow your workbook down.

The results appear in a task pane on the right side.

I have a four-year old workbook that I update daily. When I ran Check Performance, Excel found eight ranges where I had previously pasted stray text and then deleted it. The Check Performance offered to clear the text alignment and text properties of these empty cells. That is a great find.

More Reading

Excel 2024: Prevent Default Conversions »

January 3, 2025 - by Bill Jelen

Since the beginning of time, Excel has performed some annoying conversions. The conversions happened automatically when you imported from a CSV or Text file, Pasted from another application, or typed data in Excel.

Excel 2024: Checkboxes »

December 31, 2024 - by Bill Jelen

In late 2023, Microsoft added a checkbox icon to the Insert tab. As I write this in January 2024, the feature is still in beta. Adding a checkbox to a cell seems to be a special number format that displays True/False values as either checked boxes or unchecked boxes.

Excel 2024: New Scrolling Tricks »

December 25, 2024 - by Bill Jelen

Excel now offers horizontal scrolling and smooth scrolling. Smooth scrolling is a popular improvement, particularly for people who store a lot of text in a cell.

The Transformative Magic of Power Query M Code in Excel and Power BI

August 2024

A beginner’s guide to mastering the art of data metamorphosis to get just the data structure needed to create insightful data analysis solution

Financial Modelling in Power BI

September 2022

The only book to produce all three financial statements in Power BI.

Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

December 2021

Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business!

Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)

April 2022

Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful.

see more products »

Excel 2024: Check Performance in Excel

More Reading

Featured Products