» Entering Formulas More Quickly by Shortening Sheet Names
CATEGORY - Working with Formulas
VERSION - All Microsoft Excel Versions
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
Book Store:
Recommended Books:
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- How to Read A Financial Report
- Keys to Reading an Annual Report (Barron's Business Keys)
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
No comments have been submitted.
