how to display formulas on the sheet

[Guest]

I would like to know how display the formulas on the sheet.

 

[Bob Phillips]

Ctrl-` (character to left of numbers)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Albion]

Else you could go to "tools", "options", then in the "view" panel, tick on
"formulas".
that´ll make you see every formula by its composition rather by its result.
Enjoy !

Albion - Argentina

 

[R.VENKATARAMAN]

in my excel 2000 it changed width of the columns. can we avoid this?

 

[Bob Phillips]

not AFAIK, it does it on the basis that formulae are longer, so you need
wider columns to see them.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Gord Dibben]

Only through a macro which autofits the columns when in formula view.

Sub test()
ActiveWindow.DisplayFormulas = True 'False
Columns.AutoFit
End Sub


Gord Dibben Excel MVP

 

[R.VENKATARAMAN]

thanks for the tip. naturally only the columns in which the formula or any
other entries are there the columns are autofitted. rest of the columns
remains wider than default.
excell 2000

 

[Gord Dibben]

Yes.

If you have blank columns set to a width of 3 or 23, they will be reset to
default which is 8.43.

Other columns with data or formulas will autofit to size.

I prefer to run John Walkenbach's ListFormulas macro to list formulas, cell
addresses and results on another sheet.

http://j-walk.com/ss/excel/tips/tip37.htm

Then you don't muck about with formatting of the original sheet just to see or
print the formulas.


Gord

 

[R.VENKATARAMAN]

thanks.

Yes.

If you have blank columns set to a width of 3 or 23, they will be reset to
default which is 8.43.

Other columns with data or formulas will autofit to size.

I prefer to run John Walkenbach's ListFormulas macro to list formulas, cell
addresses and results on another sheet.

http://j-walk.com/ss/excel/tips/tip37.htm

Then you don't muck about with formatting of the original sheet just to see or
print the formulas.


Gord