Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

modifying column headers

Status
Not open for further replies.

david7777777777

Programmer
Sep 26, 2001
417
US
In Excel, how do you change the column labels (A, B, C) to read (1, 2, 3)? I'm looking at a spreadsheet that has both rows and columns labeled with 1, 2, 3, etc. Trying to figure out how to change the columns back to A, B, C.
Thanks.
 
Under "Tools - Options - General", de-activate the "R1C1 reference style"

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top