Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 6th 06, 08:36 PM posted to microsoft.public.excel.misc
monir
 
Posts: n/a
Default Worksheet Column Labels ... Alphabet or Numeric ?

Hello;

When I open myBook.xls, the worksheet column labels are displayed, for a
mysterious reason, as 1, 2, 3, ..., etc.
Now, while myBook.xls is open, when I open any other w/b or even a new w/b,
its column labels are displayed also as 1, 2, 3, ...

Close everything. Now open a w/b that, for whatever reason, displays its
column labels as A, B, C, ..., and re-open myBook.xls. The latter now
displays the column labels as A, B, C, ...

1. Could you please advise on why this is happening ??
2. Are the w/s column labels (alphabet, numeric, Greek symbols, etc.) an
aplication option or a w/b setting ??
3. Where is this option selected, if any ??

Thank you kindly.

  #2   Report Post  
Old April 6th 06, 08:48 PM posted to microsoft.public.excel.misc
Michael
 
Posts: n/a
Default Worksheet Column Labels ... Alphabet or Numeric ?

Hi Monir. After you open a file, all subsequent files that you open will
have the same characteristics. Go to the Tools menu, Options and select the
General tab. When the Column labels are numeric the R1C1 reference style box
is checked. Uncheck it. HTH
--
Sincerely, Michael Colvin


"monir" wrote:

Hello;

When I open myBook.xls, the worksheet column labels are displayed, for a
mysterious reason, as 1, 2, 3, ..., etc.
Now, while myBook.xls is open, when I open any other w/b or even a new w/b,
its column labels are displayed also as 1, 2, 3, ...

Close everything. Now open a w/b that, for whatever reason, displays its
column labels as A, B, C, ..., and re-open myBook.xls. The latter now
displays the column labels as A, B, C, ...

1. Could you please advise on why this is happening ??
2. Are the w/s column labels (alphabet, numeric, Greek symbols, etc.) an
aplication option or a w/b setting ??
3. Where is this option selected, if any ??

Thank you kindly.



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
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 06:16 PM
Match a value from a column in worksheet WilliamVierra Excel Worksheet Functions 2 August 10th 05 04:49 PM
Inserting Filtered RC cell information into other worksheets Dennis Excel Discussion (Misc queries) 10 July 30th 05 01:54 AM
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns Sam via OfficeKB.com Excel Worksheet Functions 4 July 14th 05 09:15 PM
grand total column B from every worksheet in workbook igor Excel Discussion (Misc queries) 2 February 23rd 05 08:42 PM


All times are GMT +1. The time now is 05:59 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017