home/Knowledge Base/Financial Modeling Questions/How do I stop long formula cells from covering adjacent cells in Excel?

How do I stop long formula cells from covering adjacent cells in Excel?

85 views 0 August 22, 2020 Updated on November 26, 2022

Follow the process below and this should disable the editing within the cell and limit the formula to the formula bar at the top.

File > Options > Advanced > UNCHECK Allow Editing In Cells

Was this helpful?

Related Articles

Strikethrough Lines Appear in Certain Cells After Downloading and Using an A.CRE Model
Waterfall Distribution % and Promote Calculation
Macros are disabled – I downloaded your model and the macros are disabled. How do I enable them?
I need help to modify (customize) the model
Is debt yield always calculated on the first loan amount (total loan amount) rather than the present value considering amortizing each year?
In an acquisition investment where the company is going to renovate all the units in the first 2 years (50% each year), how can we calculate the net cash flow yield on cost?

No luck finding what you need? Contact Us

How do you print the Excel files? How Can I Share Models with Lenders, Partners, and Others?

How do I calculate the projected return on cost at exit?