Removing the Formula Bar from Excel Worksheets PSS ID Number: Q37739 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.00 2.01 2.10 3.00

WINDOWS

Summary:

There are two ways to turn off Microsoft Excel’s formula bar. The first way is the same for both Excel 3.0 and Excel 2.x. This is the easiest way; it takes effect immediately and can be accomplished by a menu command from within Excel.

The second way involves a modification of the EXCEL.INI file for Excel 3.0 or the WIN.INI file for Excel 2.x.

More Information:

## Removing the Formula Bar Using Excel’s Menu Commands (3.0 and 2.x)

- From the Options menu, choose Workspace.
- Clear the Formula Bar check box.

## Removing the Formula Bar by Modifying EXCEL.INI for Excel 3.0

- Make sure Excel is not running. This can be done by pressing CTRL+ESC and ensuring that Microsoft Excel is not listed on the Task List.
- Open the EXCEL.INI text file using the Windows Notepad. The EXCEL.INI file is usually in the WINDOWS directory.
- Find the OPTIONS= line.
- Subtract 2 from the integer on the right of the equal sign. For example, if the line reads OPTIONS=327, change it to OPTIONS=325.
- Save the modified EXCEL.INI file.

When Excel is executed, the formula bar will not be displayed.

## Removing the Formula Bar by Modifying WIN.INI for Excel 2.x

- Open the WIN.INI file with any text editor.
- Locate OPTIONS= line under the [Microsoft Excel] section.
- Subtract 2 from the integer on the right of the equal sign. For example, if the line reads OPTIONS=87, change it to OPTIONS=85.
- Save the modified WIN.INI file.

After restarting Windows and Excel, the Formula Bar will not be displayed.

Additional reference words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00 3.0

Copyright Microsoft Corporation 1993.