home/Knowledge Base/Financial Modeling Questions

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

2 views August 22, 2020 mespencerburton-org 0

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

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?
I own a property and am interested in creating a ground lease and have some questions.
Are your spreadsheets fully adaptable by the user to reflect our particular needs?
How do you print the Excel files? How Can I Share Models with Lenders, Partners, and Others?