On the Protection tab clear the Hidden check box. Scroll to the Display section. The Formula Bar can be expanded either vertically or horizontally depending on your needs.
Scroll down to Display.
The formula or data from the breakpoint onward moves to the next line in the formula bar. The formula or data from the breakpoint onward moves to the next line in the formula bar. Show or hide the Formula Bar with Kutools for Excel 1. Scroll to the Display section.