On Nov 2, 8:35 am, "Bernard Liengme"
wrote:
In XL 97 to 2003: Tools | Options -open View tab; in lower third "Windows
Options" group uncheck Row and Column Headers.

In XL 2007: Office button (colourful circle at top left); Excel Options
(bottom of dialog); open Advanced group; locate Display Option for This
Worksheet; uncheck Show Row and Column Heading

best wishes

--
Bernard V Liengme
Microsoft Excel MVPwww.stfx.ca/people/bliengme
remove caps from email

"Irfan Khan" wrote in message

...

How can i hide row & column headers in excel whether through VBA or any
other
method...

ActiveWindow.DisplayHeadings = false