Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do i change column headings back to letters in excel?
Both the Row and Column headers are numbers, instead of the default letters
for columns and numbers for rows. So instead of having Cell 'A1' for instance i have Cell 'R1C1'. It makes it confusing when trying to check correct cells are used in formulas etc. How can i return the column headings to Letters? |
#2
|
|||
|
|||
Tools|options|general Tab
uncheck R1C1 Reference style Chris wrote: Both the Row and Column headers are numbers, instead of the default letters for columns and numbers for rows. So instead of having Cell 'A1' for instance i have Cell 'R1C1'. It makes it confusing when trying to check correct cells are used in formulas etc. How can i return the column headings to Letters? -- Dave Peterson |
#3
|
|||
|
|||
Go to Tools Options General tab and uncheck "R1C1
reference style". HTH Jason Atlanta, GA -----Original Message----- Both the Row and Column headers are numbers, instead of the default letters for columns and numbers for rows. So instead of having Cell 'A1' for instance i have Cell 'R1C1'. It makes it confusing when trying to check correct cells are used in formulas etc. How can i return the column headings to Letters? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
up to 7 functions? | Excel Worksheet Functions | |||
how can I change the a,b,c, column headers in excel to names | Excel Discussion (Misc queries) | |||
how do i change column labels back to letters? currently columns. | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
How do I change column labels from numbers to letters in Excel? | Excel Discussion (Misc queries) |