N
nexceluser
I am an excel 2002 user, and I am having problem putting in th
formulas. The formulas are simple, average, add, subtract, an
multiplying cells, but the real problem is in "viewing" the rows an
columns.
Normally, in excel, rows are numbered (1,2,3,4...) and columns ar
alphabatized (A,B,C,D...) In my case, both columns and rows ar
"numbered" , so putting in a formula is a pain in my neck. How d
resolve or change the view of the excel sheet so it displays th
"Letters" on the top columns part of the sheet going from left t
right, and the "numbers" rows (which is already there) from top t
bottom.
Please help, as this is really annoying in putting simple formulas a
(eg. =(B2+C2*D4)/100) - instead it has values of R1 R2 R3 and tha
makes it really hard for me to insert formulas by highlighting each ro
or column. Generally, your rows are numbered (1,2,3... ) and column
are "lettered" (A,B,C,D....)
I hope you are understanding my problem the right way, as it is hard t
explain without images what I am trying to say.
Please post your two cents here, what is going on, and how I can chang
the simple view of the sheet so it can display the proper view of th
sheet.
Cheers,
Excel Use
formulas. The formulas are simple, average, add, subtract, an
multiplying cells, but the real problem is in "viewing" the rows an
columns.
Normally, in excel, rows are numbered (1,2,3,4...) and columns ar
alphabatized (A,B,C,D...) In my case, both columns and rows ar
"numbered" , so putting in a formula is a pain in my neck. How d
resolve or change the view of the excel sheet so it displays th
"Letters" on the top columns part of the sheet going from left t
right, and the "numbers" rows (which is already there) from top t
bottom.
Please help, as this is really annoying in putting simple formulas a
(eg. =(B2+C2*D4)/100) - instead it has values of R1 R2 R3 and tha
makes it really hard for me to insert formulas by highlighting each ro
or column. Generally, your rows are numbered (1,2,3... ) and column
are "lettered" (A,B,C,D....)
I hope you are understanding my problem the right way, as it is hard t
explain without images what I am trying to say.
Please post your two cents here, what is going on, and how I can chang
the simple view of the sheet so it can display the proper view of th
sheet.
Cheers,
Excel Use