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.