Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 1
Default How do I change my column headers?

My Column headers are numbers (1,2,3) instead of letters (A,B,C). How do I
fix this?
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 35,218
Default How do I change my column headers?

in xl2003 menus:
Tools|Options|General tab
uncheck R1C1 Reference style

In xl2007:
Office button|Excel Options|Formulas|Working with formulas
uncheck R1C1 Reference style


Excel picks up this setting from the first workbook you open in that session.

If you have a co-worker who likes R1C1 Reference Style and you're unlucky enough
to open a workbook that he saved as the first workbook in that session, you'll
be making the same change again.

mrockwood wrote:

My Column headers are numbers (1,2,3) instead of letters (A,B,C). How do I
fix this?


--

Dave Peterson
  #3   Report Post  
Junior Member
 
Posts: 27
Default How to change the name of the column headers in Excel

In Microsoft Excel, the column headers are named A, B, C, and so on by default. Some users want to change the names of the column headers to something more meaningful. Unfortunately, Excel does not allow the header names to be changed.


I hope this helps!
Tim Paine
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
How to change the column headers from ABC to 123 Wendyk21 Excel Discussion (Misc queries) 3 August 24th 09 07:25 PM
Change color of row and column worksheet headers Patricia Excel Discussion (Misc queries) 2 July 24th 08 11:02 PM
How can I change column headers from numeric to alpha? Trish Excel Discussion (Misc queries) 2 October 23rd 07 08:11 PM
how do i change row and column headers to my own text? jordana456 Excel Discussion (Misc queries) 3 October 10th 07 07:51 AM
How do I change the color of my row and column headers? David DiLallo Excel Discussion (Misc queries) 1 May 25th 05 01:11 AM


All times are GMT +1. The time now is 01:23 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"