| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i change the column headings from numbers to letters
The column headers should be letters after you installed XL2007; that is the
default. To get numbers and use the R1C1 style; 1) click the Office Button (colourful circle in top left corner of Excel window) 2) click Excel Options button located at bottom of resulting panel 3) In left panel of next window, click Formulas 4) In the second grouping down "Working with Formulas", the first selection box is labelled R1C1 reference style best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "walty" wrote in message ... I have just changed to excel 2007 - cant find the r1c1 tab to change the column heading from numbers to letters - can anyone help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do columns headings change from letters to numbers? | Excel Discussion (Misc queries) | |||
| nedd to change column headings from numbers back to letters | New Users to Excel | |||
| how do i change the column headings from numbers to letters in ex | Excel Discussion (Misc queries) | |||
| How do I change headings for columns from numbers to letters? | Excel Discussion (Misc queries) | |||
| How do I change headings for columns from numbers to letters? | Excel Discussion (Misc queries) | |||
Hybrid Mode
