Formulas can be long and often take up several rows. Formulas can be made shorter by either using a range's defined Names for the references or shortening the sheet tab names.
To enter long Formulas into a cell more quickly:
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 back to more meaningful names.
Formulas containing short sheet names, see screenshot
Formulas containing long sheet names, see screenshot
Entering Formulas More Quickly by Shortening Sheet Names
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment