| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change the column headers from ABC to 123
The columns across the top of my spreadsheet use to say ABC. When I opened
up Excel today they have changed from ABC to 123. Now all of my previous worksheeets with formulas can't read and gives me ERROR. How do I change them back to say ABC |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to change the column headers from ABC to 123
Go to Tools|Options and then General Tab... uncheck R1C1 style reference -- NBVC Where there is a will there are many ways. 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=128076 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to change the column headers from ABC to 123
In XL2003: menus ToolsOptionsGeneral tabR1C1 Reference style
In XL2007: Office ButtonExcel Options Formulas'Working with formulas' R1C1 reference style If this post helps click Yes --------------- Jacob Skaria "Wendyk21" wrote: The columns across the top of my spreadsheet use to say ABC. When I opened up Excel today they have changed from ABC to 123. Now all of my previous worksheeets with formulas can't read and gives me ERROR. How do I change them back to say ABC |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to change the column headers from ABC to 123
<2007 excel:
Tools, Option, General tab, uncheck R1C1 reference style 2007 excel: big office button, Excel options, Formulas, uncheck same box :) susan On Aug 24, 2:10*pm, Wendyk21 wrote: The columns across the top of my spreadsheet use to say ABC. *When I opened up Excel today they have changed from ABC to 123. *Now all of my previous worksheeets with formulas can't read and gives me ERROR. *How do I change them back to say ABC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In MS Excel, how do I change the column ref headers from numbers . | Excel Discussion (Misc queries) | |||
| how do I change column headers from a number to a letter | Excel Discussion (Misc queries) | |||
| how do i change row and column headers to my own text? | Excel Discussion (Misc queries) | |||
| How do I change the color of my row and column headers? | Excel Discussion (Misc queries) | |||
| how can I change the a,b,c, column headers in excel to names | Excel Discussion (Misc queries) | |||
Linear Mode
