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

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.
 
D

Dave Peterson

You can't.

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

ShaneDevenshire

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.
 
Joined
Mar 24, 2013
Messages
1
Reaction score
0
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:

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.
 
Joined
Aug 7, 2014
Messages
1
Reaction score
0
Hi Shane,

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

Cheers,

Saul

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.
 
Joined
Feb 22, 2015
Messages
1
Reaction score
0
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
 

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

Top