» Entering Formulas in a Quicker Way by Shortening Sheet Names in Excel 2007

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.

To enter long Formulas into a cell in a quicker way:

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: