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.