MrExcel Publishing
Your One Stop for Excel Tips & Solutions

excel


Posted by nelson on September 04, 2001 3:10 PM

How do I change the HORIZONTAL column header atop the spreadsheet from A B C D E, ETC., TO 1 2 3 4 5 AND BACK.


Posted by Mark W. on September 04, 2001 3:18 PM

Use the Tools | Options... menu command to change
the "R1C1 reference style" setting on the "General"
tab.

Posted by NELSON on September 04, 2001 3:25 PM

I found info on this and I am putting it out there to get some help. It seems that this is R1C1 reference style. Does anyone know how to turn this on and off.

Posted by Mark W. on September 05, 2001 7:03 AM

Read the following response to your posting! (NT)