Numbered Colums

NotSoC# · Mar 6th, 2002, 06:22 AM

So how i have changed my colums from A b c d e etc. to 1 2 3 4 5........

How can i change them back to A b c

Thanx..........C

Anne Troy · Mar 6th, 2002, 06:26 AM

Tools-Options, General tab.

R1C1 ref style
Remove checkbox.

Mudface · Mar 6th, 2002, 06:26 AM

Click on Tools- Options and select the General tab. Uncheck the R1C1 reference style box.

NotSoC# · Mar 6th, 2002, 06:48 AM

Cheers folks.....that was annoying the hell out of me........

Thanx..Again.!

Mar 6th, 2002, 06:26 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Tools-Options, General tab. R1C1 ref style Remove checkbox. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 06:22 AM	#1
NotSoC# New Member Join Date: Mar 2002 Posts: 3	So how i have changed my colums from A b c d e etc. to 1 2 3 4 5........ How can i change them back to A b c Thanx..........C

Mar 6th, 2002, 06:26 AM	#3
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Click on Tools- Options and select the General tab. Uncheck the R1C1 reference style box.

Mar 6th, 2002, 06:48 AM	#4
NotSoC# New Member Join Date: Mar 2002 Posts: 3	Cheers folks.....that was annoying the hell out of me........ Thanx..Again.!