Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column headings display as a numbers
Occasionally when I launch excel the column headings and row are displayed as
numbers. As a result if you click in cell A1 it will display in the cell reference box as R1C1. Thus I can not figure out how to type in formulas or review them since I have not idea what these references mean. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column headings display as a numbers
Under Tools - Options, General:
Uncheck R1C1 style reference. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Cynthia" wrote: Occasionally when I launch excel the column headings and row are displayed as numbers. As a result if you click in cell A1 it will display in the cell reference box as R1C1. Thus I can not figure out how to type in formulas or review them since I have not idea what these references mean. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column headings display as a numbers
Uncheck ToolsOptionsGeneral'R1C1' reference style
If this post helps click Yes --------------- Jacob Skaria "Cynthia" wrote: Occasionally when I launch excel the column headings and row are displayed as numbers. As a result if you click in cell A1 it will display in the cell reference box as R1C1. Thus I can not figure out how to type in formulas or review them since I have not idea what these references mean. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column headings display as a numbers
Thank you very much. We had no idea why this happens on occasion.
"Cynthia" wrote: Occasionally when I launch excel the column headings and row are displayed as numbers. As a result if you click in cell A1 it will display in the cell reference box as R1C1. Thus I can not figure out how to type in formulas or review them since I have not idea what these references mean. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column headings display as a numbers
Excel picks up this setting from the first workbook you open in that session.
If you're unlucky enough that your first workbook opened is in R1C1 reference style, you'll have to make the change. Do you save the workbook after you make the change to A1 reference style? Do you have a coworker who likes R1C1 and saves it that way? (Could mean a fight!) Cynthia wrote: Thank you very much. We had no idea why this happens on occasion. "Cynthia" wrote: Occasionally when I launch excel the column headings and row are displayed as numbers. As a result if you click in cell A1 it will display in the cell reference box as R1C1. Thus I can not figure out how to type in formulas or review them since I have not idea what these references mean. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column headings display as a numbers
Excel picks up this setting from the first workbook you open in that session.
If you're unlucky enough that your first workbook opened is in R1C1 reference style, you'll have to make the change. Do you save the workbook after you make the change to A1 reference style? Do you have a coworker who likes R1C1 and saves it that way? (Could mean a fight!) Cynthia wrote: Thank you very much. We had no idea why this happens on occasion. "Cynthia" wrote: Occasionally when I launch excel the column headings and row are displayed as numbers. As a result if you click in cell A1 it will display in the cell reference box as R1C1. Thus I can not figure out how to type in formulas or review them since I have not idea what these references mean. -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column headings display as a numbers
Excel picks up this setting from the first workbook you open in that session.
If you're unlucky enough that your first workbook opened is in R1C1 reference style, you'll have to make the change. Do you save the workbook after you make the change to A1 reference style? Do you have a coworker who likes R1C1 and saves it that way? (Could mean a fight!) Cynthia wrote: Thank you very much. We had no idea why this happens on occasion. "Cynthia" wrote: Occasionally when I launch excel the column headings and row are displayed as numbers. As a result if you click in cell A1 it will display in the cell reference box as R1C1. Thus I can not figure out how to type in formulas or review them since I have not idea what these references mean. -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column headings display as a numbers
Oops.
Sorry about the multiple posting. Dave Peterson wrote: Excel picks up this setting from the first workbook you open in that session. If you're unlucky enough that your first workbook opened is in R1C1 reference style, you'll have to make the change. Do you save the workbook after you make the change to A1 reference style? Do you have a coworker who likes R1C1 and saves it that way? (Could mean a fight!) Cynthia wrote: Thank you very much. We had no idea why this happens on occasion. "Cynthia" wrote: Occasionally when I launch excel the column headings and row are displayed as numbers. As a result if you click in cell A1 it will display in the cell reference box as R1C1. Thus I can not figure out how to type in formulas or review them since I have not idea what these references mean. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column headings to numbers and row headings to alphabets? | Excel Discussion (Misc queries) | |||
How do I display an excel wrksht without column headings (A,B,C)? | Excel Discussion (Misc queries) | |||
column headings in numbers vs letters | Excel Discussion (Misc queries) | |||
Column Headings are numbers | New Users to Excel | |||
column headings display as numbers | Setting up and Configuration of Excel |