Home Blog Archive MS Office Excel: Formula bar - display- as is

Excel: Formula bar - display- as is

  • Oct 02, 2025
  • 582
  • 5

How to display the Formula bar in Excel will show you our instructions for Excel 2007 and 2010.

Formula bar in Excel show Excel 2007

  1. Open Excel 2007 and click the Office Button in the top left.
  2. Select "Excel options" and scroll down in the "Advanced" tab to "display".
  3. Activate the check box "edit line".
Excel: Formula bar view

Formula bar in Excel show Excel 2010

  1. Click in Excel 2010, click "file" and then "options".
  2. Select the tab "Advanced" and go a few sections down to "display".
  3. Here you can activate the Checkbox "edit row" and confirm with "OK".

YOU MAY ALSO LIKE

Rules in Outlook to create

  • Tue 23, 2025
  • 520
  • 0

Problems with Outlook-Login

  • Thu 25, 2025
  • 430
  • 0

5 COMMENTS

SUBJ1, Thu 26, 2020

Note : You can also get this Show Formula bar option by clicking the File (or Office button) Options Advanced Display Show Formula bar .

SUBJ1, Wed 22, 2020

My problem is the tiny bar (edit formula) on the left side of that formula bar is hidden and formula bar is stretched across the whole place. Any idea to solve this?

SUBJ1, Wed 22, 2020

We can display or hide the Formula Bar under View tab in Excel Ribbon with Formula Bar option in the Show group. If you want to show the Formula Bar, check the Formula Bar option; if you want to hide the Formula Bar, uncheck it.

SUBJ1, Thu 23, 2020

Click the Kutools Work Area, it will automatically maximize the Excel window by hiding the Status Bar, Formula Bar, and Ribbon. If you need to restore the default Excel window, just click the first button in the Work Area Size window.

SUBJ1, Fri 24, 2020

To maximize workspace in your worksheet, we may want to hide the Excel formula bar. And you can do this by unchecking the Formula bar option in the Another way to expand the formula bar in Excel is by using the shortcut Ctrl + Shift + U. To restore the default formula bar size, press this shortcut again.

LEAVE A COMMENT

Human?
1 + 3 =