Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Format
Can the column references - A B C, etc. and row reverence - 1 2 3, etc be
changed? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Format
Can the column references - A B C, etc. and row reverence - 1 2 3, etc be changed? No I don't think so. You may change it as R1C1 format, but I don't think it is what you want. Or try non-MS Excel :P |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Format
Ray
You cannot change the A, B, C headers and 1,2,3 headers. A workaround is to use Row 1 for a titles row then select A2 and WindowFreeze Panes so that Row 1 with the titles remains in view when you scroll. Select B2 instead if you also want Column A to remain in view. You can turn off the A, B, C, etc. by going to ToolsOptionsView and uncheck "row and column headers". Gord Dibben Excel MVP On Fri, 2 Dec 2005 14:51:01 -0800, "2701Ray" wrote: Can the column references - A B C, etc. and row reverence - 1 2 3, etc be changed? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
Excel 2003 to 95 File format conversion | Excel Discussion (Misc queries) | |||
Excel 2003, It wont print in landscape format | Excel Discussion (Misc queries) | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) |