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 MVP
www.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...