View Excel Cell Location

[Peggy_F]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I'm new to the Mac, previously used PC. When I open Excel, the row at the top are numbers instead of letters. Can't find anything in preferences, it's making it hard for me to understand the calculations. Thanks.

 

[CyberTaz]

It sounds like you were on the right track but gave up a bit too soon ;-)

Excel> Preferences> General, remove the check on "Use R1C1 reference style".

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Peggy_F]

I kept working on it and finally figured it out. I'm so used to the PC "speak" I don't immediately recognize the answer when I see it. Some rainy day I will have to read what the R1C1 reference style is about. Thanks so much for the quick response!

 

[Phillip Jones, C.E.T.]

That's the old Lotus123 format. Why its still around I don't know. I am
not sure Lotus even makes a Spreadsheet program anymore for Mac or PC.
My brother uses Lotus notes at work.

 

[Jim Gordon Mac MVP]

That's the old Lotus123 format. Why its still around I don't know. I am
not sure Lotus even makes a Spreadsheet program anymore for Mac or PC.
My brother uses Lotus notes at work.

The R1C1 format is handy when you want to use worksheet formulas in
Visual Basic macros. By switching to R1C1 format you can simply copy and
paste a formula into a Macro. That may not be important in Excel 2008,
as it has no VBA, but it will be very important in Excel 2011 later this
year.

-Jim