Tidy up Your Excel Spreadsheet With the New TRIMRANGE Function

This means that Excel won’t return thousands of zeros if the calculation references empty cells.

Excel also lets you be more targeted with your use of TRIMRANGE by using Trim References.

punch in

Example

Description

Trailing trim (:.)

A1:.E10

Trim trailing blanks

Leading trim (.

:E10

Trim leading blanks

Full trim (.:.)

Lucas Gouveia / How-To Geek |Kamil Zajaczkowski/ Shutterstock