Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do I change column heading names in Excel database spreadsheet

All I want to do is change the column heading names so that when I go from
spreadsheet to database layout, I can choose "First Name" rather than "A" (to
choose which fields I want to print on my address labels.) I have tried all
the help files to no avail... You would think this would be easy - I hope it
is and I'm just missing it somewhere! :o)
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 70
Default How do I change column heading names in Excel database spreadsheet

Unfortunately, it is impossible to do what you want. The column and row
headings are there to identify the cell and cannot be changed to words.

"jaymilisa" wrote:

All I want to do is change the column heading names so that when I go from
spreadsheet to database layout, I can choose "First Name" rather than "A" (to
choose which fields I want to print on my address labels.) I have tried all
the help files to no avail... You would think this would be easy - I hope it
is and I'm just missing it somewhere! :o)

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default How do I change column heading names in Excel database spreadsheet

Hi jaymilisa

Only way is to use freeze panes in the Data menu to freeze the first row and in Toolsoptions
uncheck column and row headers

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"jaymilisa" wrote in message ...
All I want to do is change the column heading names so that when I go from
spreadsheet to database layout, I can choose "First Name" rather than "A" (to
choose which fields I want to print on my address labels.) I have tried all
the help files to no avail... You would think this would be easy - I hope it
is and I'm just missing it somewhere! :o)

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
Converting Excel spreadsheet with formulae to Access database AndyL82 Excel Discussion (Misc queries) 1 February 3rd 07 06:53 PM
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 06:16 PM
How do you change the column names in Excel? flutterfly Excel Discussion (Misc queries) 1 May 20th 05 09:56 PM
Column A is Town, Column B is names. How can Excel add & tell how. Cindy Charts and Charting in Excel 3 January 13th 05 07:27 PM
how can I change the a,b,c, column headers in excel to names espray Excel Discussion (Misc queries) 1 January 13th 05 02:01 AM


All times are GMT +1. The time now is 02:16 AM.

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

About Us

"It's about Microsoft Excel"