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

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