| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
why are my columns labelled with numbers?
Instead of having columns labelled A, B, C etc, my columns are labelled 1,2,3
etc. My rows are still labelled 1,2,3 but now I can't reference a cell like A1. This hasn't happened before but seemed to occur when I exported an access database for analysis in excel. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why are my columns labelled with numbers?
Tools|Options|General tab|Uncheck R1C1 reference style.
This setting is picked up from the first workbook you open in the session. If you're unlucky, you may have to change this again. So you'll want to remember it. ec17 wrote: Instead of having columns labelled A, B, C etc, my columns are labelled 1,2,3 etc. My rows are still labelled 1,2,3 but now I can't reference a cell like A1. This hasn't happened before but seemed to occur when I exported an access database for analysis in excel. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why are my columns labelled with numbers?
Try this:
From the Excel main menu: <tools<options<general tab Uncheck: R1C1 reference style Does that help? *********** Regards, Ron XL2002, WinXP "ec17" wrote: Instead of having columns labelled A, B, C etc, my columns are labelled 1,2,3 etc. My rows are still labelled 1,2,3 but now I can't reference a cell like A1. This hasn't happened before but seemed to occur when I exported an access database for analysis in excel. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why are my columns labelled with numbers?
hi,
on the tool bar go to Toolsoptionsgeneral tab uncheck R1C1 reference style. regards FSt1 "ec17" wrote: Instead of having columns labelled A, B, C etc, my columns are labelled 1,2,3 etc. My rows are still labelled 1,2,3 but now I can't reference a cell like A1. This hasn't happened before but seemed to occur when I exported an access database for analysis in excel. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why are my columns labelled with numbers?
<Tools <Options <General tab,
and *UNCHECK* "R1C1 reference style". -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "ec17" wrote in message ... Instead of having columns labelled A, B, C etc, my columns are labelled 1,2,3 etc. My rows are still labelled 1,2,3 but now I can't reference a cell like A1. This hasn't happened before but seemed to occur when I exported an access database for analysis in excel. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro preparing numbers to be booked (columns to be chosen conditionally) | Excel Worksheet Functions | |||
| Columns are numbers, rows letters. How do I change back? | Setting up and Configuration of Excel | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| In Excel can you merge two columns i.e. street numbers and addres. | Excel Worksheet Functions | |||
| how to build a formula to match numbers in 2 columns with the equ. | Excel Worksheet Functions | |||
Linear Mode
