Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
My excel spread sheet has numbers down left side and across top?
My spread sheet has numbers down th eleft side and numbers along the
top.......shouldn't it be letters across the top?? please help me. Dave |
#2
|
|||
|
|||
Answer: My excel spread sheet has numbers down left side and across top?
Hi Dave,
Don't worry, it's actually quite easy to change the column headings from numbers to letters in Excel. Here's how you can do it:
Once you've done this, your column headings should change from numbers to letters. If you have any trouble with these steps, feel free to ask for further clarification.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
My excel spread sheet has numbers down left side and across top?
Tools/Options/General, uncheck the R1C1 reference style checkbox
In article , dave wrote: My spread sheet has numbers down th eleft side and numbers along the top.......shouldn't it be letters across the top?? please help me. Dave |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
My excel spread sheet has numbers down left side and across to
"JE McGimpsey" wrote: Tools/Options/General, uncheck the R1C1 reference style checkbox In article , dave wrote: My spread sheet has numbers down th eleft side and numbers along the top.......shouldn't it be letters across the top?? please help me. Dave Thanks very much that worked just great.what a great system!! Dave |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
My excel spread sheet has numbers down left side and across to
How do you accomplish this in Office 2007?
"JE McGimpsey" wrote: Tools/Options/General, uncheck the R1C1 reference style checkbox In article , dave wrote: My spread sheet has numbers down th eleft side and numbers along the top.......shouldn't it be letters across the top?? please help me. Dave |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
My excel spread sheet has numbers down left side and across to
Office Button, Excel Options, Formulas.
SwatMan wrote: How do you accomplish this in Office 2007? "JE McGimpsey" wrote: Tools/Options/General, uncheck the R1C1 reference style checkbox In article , dave wrote: My spread sheet has numbers down th eleft side and numbers along the top.......shouldn't it be letters across the top?? please help me. Dave |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
My excel spread sheet has numbers down left side and across to
Thanks Bob
That worked, Do you know why this would even be an option? How can you reference a cell if numbers are on each axis? Is cell 16 thsame as 61 and how do we know its not just a "16"? Does anybody actually use this R1C1 feature, and if so why? Also why would it randomly be the default when I open a new file? Thanks for any clarification you can shed, Swat "Bob I" wrote: Office Button, Excel Options, Formulas. SwatMan wrote: How do you accomplish this in Office 2007? "JE McGimpsey" wrote: Tools/Options/General, uncheck the R1C1 reference style checkbox In article , dave wrote: My spread sheet has numbers down th eleft side and numbers along the top.......shouldn't it be letters across the top?? please help me. Dave |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
My excel spread sheet has numbers down left side and across to
No idea what you mean by "Is cell 16 thsame as 61 and how do we know its
not just a "16"? " as it doesn't make any sense. You have Rows and Columns and a cells designation is the intersection. Whether you wish refer to a cell as B2 or R2C2 is immaterial, you may elect to do it either way. SwatMan wrote: Thanks Bob That worked, Do you know why this would even be an option? How can you reference a cell if numbers are on each axis? Is cell 16 thsame as 61 and how do we know its not just a "16"? Does anybody actually use this R1C1 feature, and if so why? Also why would it randomly be the default when I open a new file? Thanks for any clarification you can shed, Swat "Bob I" wrote: Office Button, Excel Options, Formulas. SwatMan wrote: How do you accomplish this in Office 2007? "JE McGimpsey" wrote: Tools/Options/General, uncheck the R1C1 reference style checkbox In article , dave wrote: My spread sheet has numbers down th eleft side and numbers along the top.......shouldn't it be letters across the top?? please help me. Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Align cell contents on left side of sheet? | New Users to Excel | |||
change rows from left side to right side | Excel Discussion (Misc queries) | |||
rows are on the left side of the sheet, I need to move them to th. | Excel Discussion (Misc queries) | |||
ADDING WORDS TO THE LEFT SIDE OF AN EXCEL SHEET | Excel Discussion (Misc queries) | |||
tiny gray squares on left side of sheet on start up printing | Excel Discussion (Misc queries) |