Alongside Excel's TRIMRANGE function and Trim Refs operators, there are other ways to clean up your data in Excel, such as using Power Query or making the most of AI through Copilot.

TL;DR Key Takeaways : Trim Refs and TRIMRANGE are new Excel tools designed to streamline data management by automatically removing empty cells, enhancing workflow efficiency and report cleanliness.

In this guide, Excel Off The Grid explores two of these new innovative tools—`TRIMRANGE` and the `Trim References` operator—that promise to simplify how you manage and analyze data in Excel.