change column header name

  • Thread starter Thread starter Dusty
  • Start date Start date
D

Dusty

Is there anyway to make the column header display change
from the letters to a custom header row. I've tried name
the column and then turning off column/row headers, but
it's not quite what I'm going for. Can you actually edit
the A, B, C, etc. in any way?
 
Dusty,

You can't change column headers. They are either alphabetic or
numeric; they cannot have custom values. You might find it
useful to put your column headings in row 1 and freeze that row.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
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

Showing Letters For Column Headers Rather Thann Numbers ? 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
Display index of column headers in column A 9
Excel sheet with numbers as column & row headers - How? 3
Change color of row and column worksheet headers 2
Hiding Header Columns abc... in 2007 1
Change the properties of the worksheet row or column header bars 6
Column Headers 1

Back
Top