ExcelBanter - How do I hide formulas in Excel cells?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I hide formulas in Excel cells? (https://www.excelbanter.com/excel-discussion-misc-queries/13243-how-do-i-hide-formulas-excel-cells.html)

Rita

How do I hide formulas in Excel cells?

I have a worksheet with lots of different formulas. I need to have the
complete sheet show the formulas and not the results. I did this before a
few years ago but don't remember how. I am working on Excel 2000. Any help
would be greatly appreciated.

Gary Brown

TOOLS / OPTIONS / FORMULAS
HTH,
Gary Brown

"Rita" wrote:

I have a worksheet with lots of different formulas. I need to have the
complete sheet show the formulas and not the results. I did this before a
few years ago but don't remember how. I am working on Excel 2000. Any help
would be greatly appreciated.

Bill Kuunders

< cntrl < ~
control tilde
below the esc key
Regards
Bill K
"Rita" wrote in message
...
I have a worksheet with lots of different formulas. I need to have the
complete sheet show the formulas and not the results. I did this before a
few years ago but don't remember how. I am working on Excel 2000. Any
help
would be greatly appreciated.

All times are GMT +1. The time now is 06:53 PM.