Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2
Default Renaming Columns A, B, C, D, E, etc. in Excel?

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.
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 35,218
Default Renaming Columns A, B, C, D, E, etc. in Excel?

You can't.

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



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.


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2,344
Default Renaming Columns A, B, C, D, E, etc. in Excel?

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Renaming Files w/Excel Confused VB Person Excel Discussion (Misc queries) 4 March 21st 08 10:26 AM
Renaming columns in MS Query RhysPieces Excel Discussion (Misc queries) 2 September 10th 07 07:40 PM
Renaming Columns Peter Excel Discussion (Misc queries) 4 April 4th 06 07:12 AM
renaming columns Timewalker Excel Discussion (Misc queries) 2 February 10th 06 01:56 AM
Excel, renaming columns Treasuris Excel Worksheet Functions 1 September 27th 05 02:03 AM


All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"