How-To Geek on MSN

You need to know what the hash sign does in Excel formulas

Smash the hash in a flash!
Hosted on MSN

How to Use TRIMRANGE & Trim Ref Operators to Tidy Up an Excel Spreadsheet

Looking for a way to tidy up your spreadsheet and reduce its size without having to use dynamic range formulas like OFFSET, INDEX, or TOCOL? TRIMRANGE detects the cells your data occupies and ...