Formulas can be made shorter by either using Named cells (read more in page 140) for the references or by shortening the sheet tab names.



1. Rename the sheets to shorter names, such as 1, 2 or 3, to make the formulas shorter.
2. After entering the formulas, change the sheet names to more meaningful names.

Formulas containing long sheet names:


Formulas containing short sheet names: