Hide Column Headers

  • Thread starter Thread starter mankoni
  • Start date Start date
M

mankoni

Under Tools there is an option to hide BOTH Row& Column Headers.

How do I hide ONLY the column headers?
 
Can't be done.

You could kind of simulate it.

Turn off both headers
and use Column A to hold your own row numbers. But I wouldn't do this. It's
too much work when you add/delete rows.
 
If you do use Dave's suggestion you could put =ROW() in A1 and copy down,
this would make it easier if you have to add and delete rows

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
You must log in or register to reply here.

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

filter on excel table with msquery and replaced header 1
Print macro that hides rows before printing 1
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
row header missing 1
Hide Row Numbers/Column Letter in VBA 1
Return value in an table with variable columns and rows 2
Hide rows in table based on 1 empty cel of the same row. 1
Hiding Header Columns abc... in 2007 1

Back
Top