How to Hide Row & Column Headers in Excel ?

G

Guest

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

Bernard Liengme

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
 
R

retsb

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
Click to expand...

ActiveWindow.DisplayHeadings = false
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel sheet with numbers as column & row headers - How? 3
How do I hide the column and row default headers in Excel? 4
Hiding Header Columns abc... in 2007 1
Display index of column headers in column A 9
Excel 2007 - freeze multiple panes? 2
Colunmn headers 4
How pull ID#s that meet specific "yes" requirements 3
Missing Column Headers / Can't scroll to top 2

Top