Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Renaming Files w/Excel | Excel Discussion (Misc queries) | |||
Renaming columns in MS Query | Excel Discussion (Misc queries) | |||
Renaming Columns | Excel Discussion (Misc queries) | |||
renaming columns | Excel Discussion (Misc queries) | |||
Excel, renaming columns | Excel Worksheet Functions |