Hide / show the Formula Bar in Excel

Many times when calculating and processing data, you accidentally hide the formula bar in Excel without knowing it, until you need to use it, you do not know how to display the formula bar again.

The following article will guide you how to hide / show the formula bar in Excel spreadsheets.

Step 1: First, you need to open the Excel file to display the formula bar, on the interface, select the View tab on the toolbar.

Hide / show the Formula Bar in Excel Picture 1

Step 2: In the View tab , in the Show / Hide section, select the box before Formula Bar , the Excel formula bar will be displayed immediately.

In contrast to hide the formula bar you unmarked in the box before Formula Bar .

Hide / show the Formula Bar in Excel Picture 2

With two very simple steps you can hide / show the formula bar in Excel, you will not need to worry every time you do not see the formula bar displayed. Good luck!