| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Reference
How do I change the column references from numbers back to letters? I.e.
instead of my cell being named A8, I show it as R8C1. How do I change my column reference structure back to alphabetical vice numeric? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Reference
Tools Options General uncheck R1C1 Reference style
-- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "mrawesomo" wrote in message ... How do I change the column references from numbers back to letters? I.e. instead of my cell being named A8, I show it as R8C1. How do I change my column reference structure back to alphabetical vice numeric? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Reference
hi
on the menu bar.... Toolsoptionsgeneral tab uncheck R1C1 reference style regards FSt1 "mrawesomo" wrote: How do I change the column references from numbers back to letters? I.e. instead of my cell being named A8, I show it as R8C1. How do I change my column reference structure back to alphabetical vice numeric? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| column 2 to transpose using column 1 as reference | Excel Discussion (Misc queries) | |||
| Column reference and column count | Excel Discussion (Misc queries) | |||
| Row reference increment but preserve column reference | Excel Worksheet Functions | |||
| Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) | |||
| I need to find the Average from Column A - but Reference Column B | Excel Worksheet Functions | |||
Linear Mode
