columns and rows labeled the same (cell 1-1 vs a-1) how do I chang

J

John

Hi Wendy
Goto>Tools>Options>General>uncheck R1C1 reference style.
HTH
John
P.S. You should write your message in this big white space not only on the
subject title.
 
W

Wendy

thanks, never had to ask a question before...we just upgraded to 2007, where
is the tools option???
 
A

Alojz

The biggest icon in upper left corner (Office button) -> Options of Excel
appliation (bottom section of the window) -> Formulas (left panel) -> Work
with formulas (middle section of right panel) -> Reference style (all is my
translation, I am not native english speaker neither my Excel :) )
 
B

Bernard Liengme

Office | Excel Options (at bottom of window) | Formulas (at left side panel)
| "working with Formulas " (second group down) | uncheck "R1C1 reference
style" (first item)
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to rename the head A,B,C,D,E etc. on every column 0
I want to get rid of columns with numbers as headings, how do I? 0
Columns went from ABCDEF to 123456. How do I fix? 1
How do I change column headings fron numbers to letters in excell. 2
How do I change headings for columns from numbers to letters? 2
how can i change the letters in the top row to words 0
How do I change the column headings (from "A" to something else)? 0
How do I split a cell into multiple rows/columns? 1

Top