| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel column identification
The copy of Excel downloaded from Microsoft for my home PC comes up with
numbered rather than lettered column identifications. Although relative and absolute addresses seem to be pretty intuitive (identified something like [R-1,C-3] for relative addresses and [R1,C4] for absolute addresses, I'm much more familiar with having columns lettered and rows numbered. I presume there's a toggle or set up feature to select one or the other but have been unable to find it. Has anyone out there encountered this? If so, what/where is the solution? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel column identification
Tools|Options|general tab|uncheck R1C1 reference style
Excel picks this up from the first workbook you opened in that session. You may have to do it again. EngineerOldie wrote: The copy of Excel downloaded from Microsoft for my home PC comes up with numbered rather than lettered column identifications. Although relative and absolute addresses seem to be pretty intuitive (identified something like [R-1,C-3] for relative addresses and [R1,C4] for absolute addresses, I'm much more familiar with having columns lettered and rows numbered. I presume there's a toggle or set up feature to select one or the other but have been unable to find it. Has anyone out there encountered this? If so, what/where is the solution? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel column identification
Dave,
Thanks for the reply - just what I needed. I knew it had to be somewhere. EngineerOldie "Dave Peterson" wrote: Tools|Options|general tab|uncheck R1C1 reference style Excel picks this up from the first workbook you opened in that session. You may have to do it again. EngineerOldie wrote: The copy of Excel downloaded from Microsoft for my home PC comes up with numbered rather than lettered column identifications. Although relative and absolute addresses seem to be pretty intuitive (identified something like [R-1,C-3] for relative addresses and [R1,C4] for absolute addresses, I'm much more familiar with having columns lettered and rows numbered. I presume there's a toggle or set up feature to select one or the other but have been unable to find it. Has anyone out there encountered this? If so, what/where is the solution? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i multiply two columns | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
| Excel should provide an easy way to switch a column into a row, n. | Excel Discussion (Misc queries) | |||
Linear Mode
