| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change excel sheet from R1C1 for cells to A1 for cell?
I'm working in an excel spreadsheet that has a row of "1" and a column of "1"
resulting a cell being R1C1. How do I change that be a row of "1" column of "A"? And why wont it let me copy my formulas into other fields? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I change excel sheet from R1C1 for cells to A1 for cell?
ToolsOptionsGeneral tab, Uncheck R1C1 Reference style
I don't know what you mean: "wont let me copy" What happens? -- Kind regards, Niek Otten Microsoft MVP - Excel "plock" wrote in message ... | I'm working in an excel spreadsheet that has a row of "1" and a column of "1" | resulting a cell being R1C1. How do I change that be a row of "1" column of | "A"? And why wont it let me copy my formulas into other fields? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I delete source links and change the current sheet accord. | Excel Worksheet Functions | |||
| Formulas not recalculating when values change on another sheet | Excel Worksheet Functions | |||
| In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
| How do I change the Excel 2000 sheet tab size? It's too small. | Excel Discussion (Misc queries) | |||
| Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Linear Mode
