Software

Ask something
Discussion Locked

Excel - How do I name my columns?

0 helpful
8 replies

by penguinsrule 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi, Currently my spreadsheets have letters for the column heading - i.e. A, B, C, D, E, F, G, etc. I've seen spreadsheets from other people where they name the columns, like NAME, ADDRESS, STATE, etc.
I've tried looking in help, but I can't figure out how to do this. can anyone help me? thanks so much

8 replies

by gary56789

Click Tools--Options--View tab--uncheck "Row & column headers"--OK. Now you can make the headers say anything ou want.

by jdclyde

in the top few rows you put in the titles you want. After this is done, you go under EDIT and you want to "FREEZE" titles by row. This will make it so as you scroll down, the titles will ALWAY show up at the top.

by penguinsrule

THANK YOU SO MUCH FOR THIS ANSWER!!!! I'VE BEEN TRYING TO FIGURE OUT HOW TO DO THIS FOR ABOUT 2 YEARS NOW, I AM SO THANKFUL!!!!!!!!!!!!!!

by penguinsrule

THANK YOU SO MUCH FOR THIS ANSWER!!!! I'VE BEEN TRYING TO FIGURE OUT HOW TO DO THIS FOR ABOUT 2 YEARS NOW, I AM SO THANKFUL!!!!!!!!!!!!!!

This discussion is closed to new replies.