Options: Display

In the Display tab of the Options dialog box, you can configure the screen by selecting items to display on the screen.

Steps

To set display

  1. Click File > Options.
  2. In the Options dialog box, select the Display tab.
  3. In Window Select Option, select Formula and click Set.
  4. Type =2+3 in the cell A1 in a worksheet and press ENTER.
  5. The formula =2+3 instead of the result value 5 will be displayed in the cell A1.

More Information

Display Tab of Options Dialog Box

New Workbook

Display

To display or hide the formula bar or the status bar in a worksheet, select or clear the check box.

Comment

Specify how to display comments in a worksheet.

Worksheet Select Option

Select options for displaying the active window.

Workbook Select Option

Select options for the workbook.

See Also