My "edit line" is missing from Excel 2000.

[PatNM]

When I open an Excel spreadsheet, there is no "edit line." That means I have
to make all corrections in the cells, making it necessary to retype all
information in the cell. How can I restore the "edit line" in Excel
(Microsoft Office 2000)?

[keithl816]

If you are talking about the formula bar go to Tools/Options/View

Under Show put a check in the formula bar box.

Larry

[Chip Pearson]

I assume by "edit line" you mean the Formula Bar. Go to the Tools
menu, choose Options, then the View tab. There, ensure that
"Formula bar" is checked.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"PatNM" <[email protected]> wrote in message
news:[email protected]...
> When I open an Excel spreadsheet, there is no "edit line."
> That means I have
> to make all corrections in the cells, making it necessary to
> retype all
> information in the cell. How can I restore the "edit line" in
> Excel
> (Microsoft Office 2000)?

[Ken Johnson]

Hi Pat,
Click on View in the menu bar then select Formula bar.
Ken Johnson