Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
sholstadjr
 
Posts: n/a
Default The columns always were A, B, C, D,... They are now numbers. How.

The settings on my Excel have changed from the columns showing letters
(a,b,c,...) to now showing numbers just like the rows are labeled. How can I
change it back to the traditional setting??
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Tools|options|General Tab|uncheck the R1C1 reference style box.

sholstadjr wrote:

The settings on my Excel have changed from the columns showing letters
(a,b,c,...) to now showing numbers just like the rows are labeled. How can I
change it back to the traditional setting??


--

Dave Peterson
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
print excel columns on less pages a_ryan1972 Excel Discussion (Misc queries) 1 February 9th 05 05:41 PM
Convert multiple columns to rows Lois Lane Excel Worksheet Functions 8 January 10th 05 12:47 AM
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 06:37 PM
Counting the Contents of Two Columns Molochi Excel Discussion (Misc queries) 6 December 22nd 04 08:13 PM
Averaging columns rhodesv New Users to Excel 1 December 16th 04 08:14 PM


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