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!

Excell column's now numbers? 1

Status
Not open for further replies.

Cheech

Technical User
Nov 6, 2000
2,933
EU
When i open a new sheet in excel the columns are numbered rather than alphabetical.

Is there a setting somewhere to correct this? Live long and make your kids suffer..
 
1. Start Excel.

2. On the Tools menu, click Options.

3. Click the General tab.

4. Under Settings, click to clear the R1C1 reference style check box (upper-left corner), and then click OK.

If you select the R1C1 reference style check box, Excel changes the reference style of both row and column headings, and cell references from the A1 style to the R1C1 style.
 
Thanks,

Like most things they are obvious once you know how they are done.

Cheech Live long and make your kids suffer..
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top