How to Hide Row & Column Headers in Excel ?
 

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

How to Hide Row & Column Headers in Excel ?
 

Tools, Options, View Tab - near bottom uncheck Row & column headers

"Irfan Khan" wrote:

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

How to Hide Row & Column Headers in Excel ?
 

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

How to Hide Row & Column Headers in Excel ?
 

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