How to Use TRIMRANGE & Trim Ref Operators to Tidy Up an Excel Spreadsheet
TRIMRANGE detects the cells your data occupies and automatically expands and contracts with ... of my data to prevent Excel from having to work too hard and keep my spreadsheet looking tidy.