Share this article
Latest news
With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low
Copilot in Outlook will generate personalized themes for you to customize the app
Microsoft will raise the price of its 365 Suite to include AI capabilities
Death Stranding Director’s Cut is now Xbox X|S at a huge discount
Outlook will let users create custom account icons so they can tell their accounts apart easier
Microsoft Excel introduces TRIMRANGE and trim references, allowing users to clean spreadsheets of unnecessary columns in just a few seconds
The feature is gradually rolling out to users.
2 min. read
Published onAugust 29, 2024
published onAugust 29, 2024
Share this article
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
Microsoft is rolling out a new preview function called TRIMRANGE for its Excel platform and a set of nifty trim references designed to simplify data and spreadsheet work. This capability will help users clean their files faster and more easily.
In a blog post, Microsoft says TRIMRANGE is all about efficiency. Imagine you’re working with dynamic array formulas or trying to boost the performance of lambda functions. This function removes those pesky empty rows from the edges of a range. That means no more unnecessary calculations running on every cell and trailing zeros messing up your data.
But how does it work? Let’s say you’re calculating the length of text entered into column A. Without TRIMRANGE, you’d get a result for every cell, including a bunch of zeros you didn’t ask for. With TRIMRANGE, it zeroes in on just the cells with text, making your formula more efficient and your spreadsheet cleaner.
TRIMRANGE is based on trim references similar to shortcuts or cheat codes. By tweaking the classic colon range operator (the A1:E5 thing), you can specify whether you want to trim blanks from the start, end, or both sides of a range. There are three types: trailing trim ref (:.), leading trim ref (.:), and full trim ref (.:.).
Trim refs are a game-changer for those who love diving into full-column references but hate how sluggish they can be. They let you focus on just the part of the column that has values, making your formulas faster and more efficient.
This shiny new function and its companions are now available to Beta Channel users running Version 2409 (Build 18020.2000) or later. If you’re not seeing it yet, don’t worry. The Redmond-based tech giant is gradually rolling them out.
TRIMRANGE and trim references in Microsoft Excel are poised to be a big deal. Likethe recently announced Python editor, they promise to make our data cleaner, our formulas faster, and our lives easier. And who couldn’t use a bit more of that?
More about the topics:Microsoft 365,Microsoft Excel
Flavius Floare
Tech Journalist
Flavius is a writer and a media content producer with a particular interest in technology, gaming, media, film and storytelling.
He’s always curious and ready to take on everything new in the tech world, covering Microsoft’s products on a daily basis. The passion for gaming and hardware feeds his journalistic approach, making him a great researcher and news writer that’s always ready to bring you the bleeding edge!
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Flavius Floare
Tech Journalist
Flavius is a writer and a media content producer with a particular interest in technology, gaming, media, film and storytelling.
