Category Archives: Quick tips

Quick tip: Make your formulas legible

By Sebastien Labonne | Published: August 25, 2009

Embedded Excel functions is certainly a great feature, but it often makes formulas really long and hard to read. You can easily make your formulas more legible by simply pressing ALT-ENTER while editing it to force a line feed. See for yourself the result of doing so. Note that you need to put the line feed (ALT-ENTER) [...]

Posted in Quick tips | Tagged Formula, Tips | Leave a comment

Search
Auditing Best Practices Conditional Format Controls Data Tables Data Validation Depreciation Error Handling Errors Excel Function Excel Functionality Find Find & Replace Format Formula Go to Input Model Model Structure OFFSET Options Pivot Tables R1C1 RAND Reference Style Scenario Sensitivity Settings Shortcuts Tables Technique Tips Trigger Tutorial Visualization
WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.
RSS updates
- All posts
- All comments
Email updates

Enter your email address:
Share this blog
Recent Posts
Recent Comments
Blogroll
Links
- ModelCom
Meta
The Financial Modeler

Category Archives: Quick tips

Quick tip: Make your formulas legible

Search

RSS updates

Email updates

Share this blog

Recent Posts

Recent Comments

Blogroll

Links

Meta

The Financial Modeler