Naming columns in Excel

P

Peggy

I am trying to set up a database in Excel. I need to change the columns (A,
B, C,...etc) to name, date, ssn, etc. I am having trouble and dont know how
to do it. PLEASE HELP!
I want to be able to have each column name to reflect the information that
will be put in that respective column.

Thank you for your help
 
F

Frank Kabel

Hi
you can't change the column headers. The best you could do is use the first
row as heading row
 
J

Jan Karel Pieterse

Hi Peggy,
I am trying to set up a database in Excel. I need to change the columns (A,
B, C,...etc) to name, date, ssn, etc. I am having trouble and dont know how
to do it. PLEASE HELP!
I want to be able to have each column name to reflect the information that
will be put in that respective column.
Click to expand...

That is impossible. The only thing you can do is use row 1 for the headings.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
M

Myrna Larson

You can't do that in Excel. You are thinking of a database program like
Access. Maybe that's what you should be using here.
 
J

Jamie Collins

Frank Kabel said:
you can't change the column headers. The best you could do is use the first
row as heading row
Click to expand...

The OP could additionally hide Excel's column headers (Tools, Options,
View, uncheck 'Row and column headers') then format the new custom
column headers in the first row to *look* like Excel's. Or get really
clever and put appropriate controls over the cells in the header row
so custom functionality could be applied when they were selected,
clicked, hovered over with the mouse, etc. It would require some other
clever tricks to ensure the custom row stays in place, though.

Jamie.

--
 
Top