Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 231
Default How do I change numeric column designations to alpha?

Sometimes Excel opens with numeric designators on columns and row. I want
alpha on the columns and numeric on the rows. Can I set that in preferences?
If now, how do I change it when it happens (seemingly at random)?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default How do I change numeric column designations to alpha?

Tools - Options - General - Uncheck R1C1

Excel however remebers the setting from the last workbook opened so don't be
surprised if it changes back.

Any help?

Mike

"Sarah" wrote:

Sometimes Excel opens with numeric designators on columns and row. I want
alpha on the columns and numeric on the rows. Can I set that in preferences?
If now, how do I change it when it happens (seemingly at random)?

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 can I change my column references from Alpha to Numeric? Danelle Boling, Sales Analyst Excel Worksheet Functions 1 August 15th 06 08:45 PM
Can I change the sort order to Alpha before Numeric? gracy Excel Discussion (Misc queries) 2 May 19th 06 10:16 PM
Change the column designation from a numeric to an alpha George Sladky Excel Discussion (Misc queries) 2 May 4th 06 03:47 PM
change excel auto column headers from numeric to alpha MarcieinHawaii Excel Discussion (Misc queries) 2 February 14th 06 10:22 PM
Column designations (A, B, C,..) are now numbers-how do I change LM Excel Discussion (Misc queries) 3 January 27th 06 10:48 PM


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