OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   Setting up and Configuration (http://www.officefrustration.com/forumdisplay.php?f=4)
-   -   Excel 2007 change column labels from numbers to letters (http://www.officefrustration.com/showthread.php?t=858448)

Victoriah June 9th, 2008 06:06 PM

Excel 2007 change column labels from numbers to letters
 
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.

Ron de Bruin June 9th, 2008 07:37 PM

Excel 2007 change column labels from numbers to letters
 
Office ButtonExcel Options

On the Formulas tab check or uncheck R1C1 reference................


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Victoriah" wrote in message ...
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.


Victoriah June 10th, 2008 05:12 PM

Excel 2007 change column labels from numbers to letters
 
Thanks, Ron! I knew there had to be a simple fix. I just couldn't find it.

"Ron de Bruin" wrote:

Office ButtonExcel Options

On the Formulas tab check or uncheck R1C1 reference................


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Victoriah" wrote in message ...
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.



Susan July 3rd, 2008 06:35 PM

Excel 2007 change column labels from numbers to letters
 
Ron

I am having same problem and I read your reply and can't fiure out what you
mean. Can you help me too?

Susan

"Ron de Bruin" wrote:

Office ButtonExcel Options

On the Formulas tab check or uncheck R1C1 reference................


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Victoriah" wrote in message ...
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.



Ron de Bruin July 3rd, 2008 06:44 PM

Excel 2007 change column labels from numbers to letters
 
Hi Susan

The Office Button is the big round circle next to the Home tab on the ribbon.
Click on it and you see a "Excel Options" button.

Click on Formulas and uncheck the R1C1 option in the "working with formulas" section

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Susan" wrote in message ...
Ron

I am having same problem and I read your reply and can't fiure out what you
mean. Can you help me too?

Susan

"Ron de Bruin" wrote:

Office ButtonExcel Options

On the Formulas tab check or uncheck R1C1 reference................


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Victoriah" wrote in message ...
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.



Susan July 3rd, 2008 06:58 PM

Excel 2007 change column labels from numbers to letters
 
Yikes - I'm no programmer - I'm sorry - can you explain where this "Home" tab
and ribbon are? Is this Visual Basic?

"Ron de Bruin" wrote:

Hi Susan

The Office Button is the big round circle next to the Home tab on the ribbon.
Click on it and you see a "Excel Options" button.

Click on Formulas and uncheck the R1C1 option in the "working with formulas" section

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Susan" wrote in message ...
Ron

I am having same problem and I read your reply and can't fiure out what you
mean. Can you help me too?

Susan

"Ron de Bruin" wrote:

Office ButtonExcel Options

On the Formulas tab check or uncheck R1C1 reference................


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Victoriah" wrote in message ...
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.



Susan July 3rd, 2008 07:04 PM

Excel 2007 change column labels from numbers to letters
 
I figured out! Thanks!

"Ron de Bruin" wrote:

Hi Susan

The Office Button is the big round circle next to the Home tab on the ribbon.
Click on it and you see a "Excel Options" button.

Click on Formulas and uncheck the R1C1 option in the "working with formulas" section

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Susan" wrote in message ...
Ron

I am having same problem and I read your reply and can't fiure out what you
mean. Can you help me too?

Susan

"Ron de Bruin" wrote:

Office ButtonExcel Options

On the Formulas tab check or uncheck R1C1 reference................


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Victoriah" wrote in message ...
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.



Pez51 November 5th, 2008 05:30 AM

Excel 2007 change column labels from numbers to letters
 
I have the same problem but with Excel 2008 for MAC. Any solutions? thnaks

"Victoriah" wrote:

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.


thanks for your reply.its very useful May 29th, 2010 11:21 AM

Excel 2007 change column labels from numbers to letters
 


"Ron de Bruin" wrote:

Office ButtonExcel Options

On the Formulas tab check or uncheck R1C1 reference................


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Victoriah" wrote in message ...
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.



rekhasein November 29th, 2010 08:18 AM

Quote:

Originally Posted by thanks for your reply.its very useful (Post 3738487)


Open Excel and click on the "Excel" menu option in the furthest top left corner. Scroll down and select "Preferences" from the menu selections. A new window will pop up.


All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
OfficeFrustration.com