Possible to hide column headers???

T

T-®ex

Hi! I'd like to know if it's possible to hide the column (and row)
"headers" in Excel... If it is, how do I do it?
 
N

Norman Jones

Hi T-®ex,

Tools | Options | View | deselect 'Row & Column headers'

If you need to do this programmatically, try something like:

ActiveWindow.DisplayHeadings = False
 
T

Tempy

Hi T-®ex,

I used the code below

Range("Headers").EntireRow.Hidden = True - For a Named range
Rows("1:1").EntireRow.Hidden = True
Columns("A:A").EntireColumn.Hidden = True


Tempy
 

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

If statement based on cell formatting/style 2
hiding blank rows 3
Hiding columns with shaded headers 4
convert columns to rows 6
Multiple SUM's in a column 15
Hide column based on data validation 0
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Top