Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I don't see anywhere to change this. I copied a client's spreadsheet and now
all of my Excel sheets have numbers for the columns and the rows. It is making it hard to do formulas. Please help! |
#2
![]() |
|||
|
|||
![]()
From the menu - select Tools | Options; click the General tab and make
sure R1C1 reference style is NOT checked. |
#3
![]() |
|||
|
|||
![]()
Toolsoptionsgeneral and uncheck R1C1 reference style
-- Regards, Peo Sjoblom "lisawjs" wrote in message ... I don't see anywhere to change this. I copied a client's spreadsheet and now all of my Excel sheets have numbers for the columns and the rows. It is making it hard to do formulas. Please help! |
#4
![]() |
|||
|
|||
![]()
Thank you very much! You were very helpful!
"lisawjs" wrote: I don't see anywhere to change this. I copied a client's spreadsheet and now all of my Excel sheets have numbers for the columns and the rows. It is making it hard to do formulas. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
FORMULAS FOR ADDING LETTERS REPRESENTING NUMBERS | Excel Discussion (Misc queries) | |||
How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
row numbers & column letters | Excel Discussion (Misc queries) | |||
How do I change column labels from numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
How do I take two columns of sequential numbers and insert spaces | Excel Discussion (Misc queries) |