Master the New TrimRange Function in Excel 2025 Tutorial

Introducing: The Essential Excel 2025 Functions Series

Master Excel’s Latest Power Features with Ease

We’re thrilled to launch a brand-new video series on the Other Levels YouTube channel —

“The Essential Excel 2025 Functions Series” — your step-by-step guide to mastering the newest and most powerful features in Excel 2025.

Whether you’re building dashboards, automating analysis, or managing large datasets, this series will help you unlock Excel’s full potential — one function at a time.

Episode 1: Mastering the New TrimRange Function in Excel 2025

Let’s begin with a real game-changer: the new TRIMRANGE function.

Microsoft recently introduced TrimRange and a companion feature called TrimRefs, both designed to simplify how we handle dynamic ranges, especially when working with calculated columns, large datasets, or tables that grow over time.

Why TrimRange Is a Big Deal

Let’s start with a common Excel challenge.

You’ve got a dataset, and you’re using a calculated column like:

=ColumnD - ColumnC

You drag the formula down, but what happens if you add new rows later? Will the formula update automatically?

Sometimes yes — especially if you’re using Excel Tables. But not always. Depending on your version of Excel, formulas might not auto-fill, or worse, you might find yourself filling down a million rows, bloating your file size and slowing down performance.

❌ The Old Way

You’d write something like:

= D:D - C:C

Yes, it works, but it fills the entire column, whether you need it or not. This leads to unnecessary calculations and bloated workbooks.

✅ The Better Way:

TrimRange

Now comes Excel 2025’s solution:

=TRIMRANGE(D:D) - TRIMRANGE(C:C)

Here’s what this does:

It trims the empty rows above and below your data range.
It intelligently calculates only the data-filled rows.
It stays dynamic, meaning when you add a new row (say row 1001), it automatically updates without dragging formulas or converting to a table.

Optional Arguments: More Power in Your Hands

TrimRange also includes optional parameters:

TRIMRANGE(range, [rowTrim], [colTrim])

rowTrim: Choose whether to trim leading or trailing rows.
colTrim: Trim blank columns if needed.
Default is both, which is perfect for most use cases.

This level of flexibility is especially useful when working with messy datasets or pre-formatted input sheets.

Introducing TrimRefs — A New Syntax Operator in Excel 2025

If TrimRange is a new function, then TrimRefs is a new way to write reference operators.

You can now write:

= .D:D - D:.C

What’s with the dots? Let’s break it down:

.D:D → trims leading rows only
D:.C → trims trailing rows only
.:. → trims both sides

This syntax may look strange at first, but it’s powerful, lightweight, and allows for cleaner formulas without needing full-blown TrimRange function calls.

Use Cases Where TrimRange & TrimRefs Shine

Dynamic dashboards with auto-expanding rows
Performance optimization for large workbooks
Avoiding bloated file sizes caused by full-column references
Cleaning messy input data from external sources

🎥 Watch the Full Tutorial

To see these functions in action, watch the full video tutorial on the Other Levels YouTube channel.

We walk you through:

A beginner-friendly exercise using TrimRange
How to future-proof your calculated columns
Exploring optional arguments
How to use TrimRefs with dot notation

What’s Next?

This is just the beginning. In upcoming videos, we’ll cover:

More 2025 Excel functions
Advanced dashboards powered by the latest features
Real-world applications that save hours of manual work

🔔 Be sure to subscribe to the Other Levels channel and hit the notification bell so you don’t miss any of the episodes in this powerful series.

Let’s Talk! 💬

What do you think about the new TrimRange and TrimRefs functions?

Have you tested them in your own reports or dashboards?

Drop your thoughts in the comments below or share your questions — we love hearing from our fellow Excel enthusiasts!

🎓 Learn More with Other Levels

Take your Excel skills to the next level:

🌐 Visit our Other Levels Website
📺 Watch free tutorials on our Other Levels YouTube Channel, and learn Microsoft Excel from beginner to advanced.

Your cart is currently empty.