Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
dan
 
Posts: n/a
Default How do you change the column names e.g. A B C D E F

How do you change the column names e.g. A B C D E F
in exel
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default How do you change the column names e.g. A B C D E F

Here are your options:
You can Show/Hide column and row headings
You can use the R1C1 style, instead of the A1 style

If you want your users to see something else, try this:
Put your "new" column headings in Row_1
Example:
A1: InputDate,
B1: Customer Name
etc

Then: ToolsOptionsView tab
Uncheck Row & Column Headers

I hope that helps?

***********
Regards,
Ron

XL2002, WinXP-Pro


"dan" wrote:

How do you change the column names e.g. A B C D E F
in exel

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
In Excel, how do I change worksheet headers (A,B) to names (Box)? Tom McGuire New Users to Excel 4 January 18th 06 05:39 PM
Positioning Numeric Values Resulting from 6 Column Array Formula Sam via OfficeKB.com Excel Worksheet Functions 2 January 5th 06 02:03 AM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 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
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 07:25 PM


All times are GMT +1. The time now is 03:48 AM.

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"