both horizontal and vertical rows are numbers

G

gen.espinoza

Can anyone help me out with this problem? Instead of one being
numbers and the other being letters I only have numbers going up and
across. Because of this I am not able to do formulas.

Thanks!
 
K

Ken Johnson

Can anyone help me out with this problem? Instead of one being
numbers and the other being letters I only have numbers going up and
across. Because of this I am not able to do formulas.

Thanks!
Click to expand...

Turn off the "R1C1 reference style" setting by deselecting it on the
"General" tab sheet of the "Preferences" dialog.
Ken Johnson
 

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

Page numbering with Merged Document and IF statements 1
Move Chart with Text 0
Improving Macro That Keeps First Letter 0
Keep First Letters, with exceptions 0
Finding the proper style field and the numbered paragraph value within the style 0
flashcard file with bad page 0
Removing Line Numbers 4
Footnote references on one page, footnote text on the next 5

Top