Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why are my colums in excel numbered as well as the rows
I have been looking at the use of formulas in excel, I do not use excel much
but all the formulas seem to need the column to be referenced with a letter. For some reason my excel has numbers for rows and columns, can I change this, if so how is it done. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why are my colums in excel numbered as well as the rows
<Tools <Options <General tab,
And *UNCHECK* "R1C1 Reference Style". -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Jazzy" wrote in message ... I have been looking at the use of formulas in excel, I do not use excel much but all the formulas seem to need the column to be referenced with a letter. For some reason my excel has numbers for rows and columns, can I change this, if so how is it done. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why are my colums in excel numbered as well as the rows
Tools Options General and clear the R1C1 checkbox
-- Gary's Student gsnu200704 "Jazzy" wrote: I have been looking at the use of formulas in excel, I do not use excel much but all the formulas seem to need the column to be referenced with a letter. For some reason my excel has numbers for rows and columns, can I change this, if so how is it done. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge from Excel to Word - why are only even rows merged? | Excel Discussion (Misc queries) | |||
Excel shared workbook copies rows by itself | Excel Worksheet Functions | |||
(Unsuccessfully!) Unhiding Rows in Excel 2003 | Excel Worksheet Functions | |||
how do I invert the rows and colums in excel? | Excel Discussion (Misc queries) | |||
i want my excel colums to be rows | Excel Worksheet Functions |