| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I change cell labelling from R1C1 to A1?
My excell is now labelling rows and columns as numbers. Instead of having
letters in the columns as usual, I prefer to say B4 when calling a cell than R4C2. How can I change that? thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I change cell labelling from R1C1 to A1?
Click TOOLS/OPTIONS on the menu and select the GENERAL tab. Remove the check
mark from R1C1 REFERENCE STYLE the first check box on the left side of the tab page. -- Kevin Backmann "agua" wrote: My excell is now labelling rows and columns as numbers. Instead of having letters in the columns as usual, I prefer to say B4 when calling a cell than R4C2. How can I change that? thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I change cell labelling from R1C1 to A1?
Toolsoptionsgeneral and clear "R1C1 reference style"
-- Regards, Peo Sjoblom "agua" wrote in message ... My excell is now labelling rows and columns as numbers. Instead of having letters in the columns as usual, I prefer to say B4 when calling a cell than R4C2. How can I change that? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change default cell reference from 'R1C1' to 'A1'? | Setting up and Configuration of Excel | |||
| Procedure to change Column heading from R1C1 to A1? | Excel Worksheet Functions | |||
| How do I change excel sheet from R1C1 for cells to A1 for cell? | Excel Worksheet Functions | |||
| R1C1 problems - Can't change | Excel Discussion (Misc queries) | |||
| Excel help should explain how to change r1c1 to a1 | Excel Discussion (Misc queries) | |||
Linear Mode
