how to display formulas on the sheet
 

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

Ctrl-` (character to left of numbers)

--

HTH

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


"flat6" wrote in message
...
I would like to know how display the formulas on the sheet.

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

"flat6" escribió en el mensaje
...
I would like to know how display the formulas on the sheet.

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


Bob Phillips wrote in message
...
Ctrl-` (character to left of numbers)

--

HTH

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


"flat6" wrote in message
...
I would like to know how display the formulas on the sheet.

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)


"R.VENKATARAMAN" wrote in message
...
in my excel 2000 it changed width of the columns. can we avoid this?


Bob Phillips wrote in message
...
Ctrl-` (character to left of numbers)

--

HTH

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


"flat6" wrote in message
...
I would like to know how display the formulas on the sheet.

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

On Thu, 17 Feb 2005 08:36:46 +0530, "R.VENKATARAMAN"
wrote:

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


Bob Phillips wrote in message
...
Ctrl-` (character to left of numbers)

--

HTH

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


"flat6" wrote in message
...
I would like to know how display the formulas on the sheet.

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 <gorddibbATshawDOTca wrote in message
...
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

On Thu, 17 Feb 2005 08:36:46 +0530, "R.VENKATARAMAN"
wrote:

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


Bob Phillips wrote in message
...
Ctrl-` (character to left of numbers)

--

HTH

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


"flat6" wrote in message
...
I would like to know how display the formulas on the sheet.

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

On Fri, 18 Feb 2005 09:10:49 +0530, "R.VENKATARAMAN"
wrote:

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 <gorddibbATshawDOTca wrote in message
.. .
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

On Thu, 17 Feb 2005 08:36:46 +0530, "R.VENKATARAMAN"
wrote:

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


Bob Phillips wrote in message
...
Ctrl-` (character to left of numbers)

--

HTH

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


"flat6" wrote in message
...
I would like to know how display the formulas on the sheet.

thanks.

Gord Dibben <gorddibbATshawDOTca wrote in message
...
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

On Fri, 18 Feb 2005 09:10:49 +0530, "R.VENKATARAMAN"
wrote:

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 <gorddibbATshawDOTca wrote in message
.. .
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

On Thu, 17 Feb 2005 08:36:46 +0530, "R.VENKATARAMAN"

wrote:

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


Bob Phillips wrote in message
...
Ctrl-` (character to left of numbers)

--

HTH

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


"flat6" wrote in message
...
I would like to know how display the formulas on the sheet.