Renaming Columns A, B, C, D, E, etc. in Excel?

  • Thread starter Thread starter Lee H.
  • Start date Start date
L

Lee H.

How can a user rename Column "A" to say "Last Name," rename Column "B" to say
"First Name," Column "C" to say "Address 1," etc?

This would allow the data to start on row #1 for automatic renumbering when
new rows are added, rather than having to put the column names on row 1,
causing the data to start on row 2.
 
You can't.

You can show letters or numbers as the column headers--or hide them. But you
can't rename them.
 
Hi Lee,

You can "sort of" do this 2007:

1. Select the range and choose Home, Format as Table and pick a style
2. As you scroll down the screen the column letters will be replaced with
the titles in the table when you reach the limit of viewing the titles.
 
Thank you very much Shane! So simple, yet so elegant!

I had seen this done in a spreadsheet and wondered how it was done. Searched the net extensively with several different keyword patterns, didn't find what I was looking for.... until I stumbled upon your response. This is the only response I have seen so far and it is perfect.

Thanks once again.

Cren :bow:

ShaneDevenshire said:
Hi Lee,

You can "sort of" do this 2007:

1. Select the range and choose Home, Format as Table and pick a style
2. As you scroll down the screen the column letters will be replaced with
the titles in the table when you reach the limit of viewing the titles.


--
Thanks,
Shane Devenshire


"Lee H." wrote:

> How can a user rename Column "A" to say "Last Name," rename Column "B" to say
> "First Name," Column "C" to say "Address 1," etc?
>
> This would allow the data to start on row #1 for automatic renumbering when
> new rows are added, rather than having to put the column names on row 1,
> causing the data to start on row 2.
Click to expand...
 
Hi Shane,

Awesome, thanks very much - from another person who Googled with the same problem and found your great solution.

Cheers,

Saul

ShaneDevenshire said:
Hi Lee,

You can "sort of" do this 2007:

1. Select the range and choose Home, Format as Table and pick a style
2. As you scroll down the screen the column letters will be replaced with
the titles in the table when you reach the limit of viewing the titles.


--
Thanks,
Shane Devenshire


"Lee H." wrote:

> How can a user rename Column "A" to say "Last Name," rename Column "B" to say
> "First Name," Column "C" to say "Address 1," etc?
>
> This would allow the data to start on row #1 for automatic renumbering when
> new rows are added, rather than having to put the column names on row 1,
> causing the data to start on row 2.
Click to expand...
 
Hello. This is just what I'm after.. but I can't seem to follow the instructions. Apologies. I'm sure it's simple. I'm just a slight tech-naive. Would you be able to help again Shane??? Would be much appreciated.
When I highlighted my table, I included my text headings, which are in row 1. They are still in row 1 and my data beings in row 2. Ideally I'd like row 2 to be row 1...

.. Thanks!

Elizabeth
 
Back
Top