Excel 2007 change column labels from numbers to letters

#10

bala_vb

Senior Member

Location: Hyderabad

Posts: 237

Quote:

Originally Posted by Victoriah

I am working in Excel 2007. Currently the column labels are showing up as
numbers naming cells as R1C1 etc. I'd much rather use letters for the
column labels so the cells will be the usual A1, B2 etc. I've searched the
help menus and have been unable to find out how to do this.

I have attached scren shot so that, it will give an idea where about R1C1 formula reference.

all the best

Attached Images

__________________
Thanks
Bala

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
Excel 2007 changed the column Letters into numbers	Bob WIFI HomeAutomation Guy	Excel Discussion (Misc queries)	1	October 1st 07 02:03 PM
How do I change the labels of my columns from numbers to letters?	Anna-Maria	Excel Discussion (Misc queries)	1	March 14th 06 06:32 PM
How do I change the labels of my columns from numbers to letters?	Anna-Maria	Excel Discussion (Misc queries)	2	March 14th 06 06:11 PM
How do I change column labels from numbers to letters?	Gregg Hillyer	Excel Discussion (Misc queries)	2	November 29th 05 09:10 PM
How do I change column labels from numbers to letters in Excel?	AllisonCincy	Excel Discussion (Misc queries)	2	December 9th 04 12:55 AM

All times are GMT +1. The time now is 05:21 PM.

Menu

About Us