How can I make the collumn headers in excel be letters rather tha.

ChristinaC

Posts: n/a

Hi Ian,
Go into Tools, Options and the General Tab. In there untick the R1C1
reference style. This should then solve your problem.

Chris

"Ian Hunt" wrote:

I have just changed laptops and now excel shows its cell references as R1C1
for cell A1 how do i make it use letters for collumns?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
How to make one CSV file from two Excel sheets?	Marek L.	Excel Discussion (Misc queries)	3	February 13th 05 07:47 PM
can I make pulldown text boxes in excel sheets	Frank	Excel Discussion (Misc queries)	1	February 11th 05 05:05 PM
Excel opens my file and a book1.xls, make it stop?	Bob	Excel Discussion (Misc queries)	6	January 7th 05 12:20 AM
Excel Headers while scrolling down	Tavish Muldoon	Excel Discussion (Misc queries)	3	December 6th 04 08:21 PM
Make copy from any document into Excel a right click with a drop .	Kat	Excel Worksheet Functions	0	December 4th 04 12:43 AM

All times are GMT +1. The time now is 10:53 PM.

Menu

About Us