Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
both columns and rows are numeric.want the columns to be alpha
in my excel sheet. the top of the columns are numeric as well as the rows. I
want the columns to be alpha??? There could be some special format or sumation happening prior to getting the excel file. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
both columns and rows are numeric.want the columns to be alpha
ToolsOptionsGeneral. Uncheck "R1C1 reference style"
Gord Dibben MS Excel MVP On Tue, 26 Sep 2006 12:31:03 -0700, amy wrote: in my excel sheet. the top of the columns are numeric as well as the rows. I want the columns to be alpha??? There could be some special format or sumation happening prior to getting the excel file. |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
both columns and rows are numeric.want the columns to be alpha
Hi Amy,
Tools | Options | General tab Uncheck R1C1 hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "amy" escreveu: in my excel sheet. the top of the columns are numeric as well as the rows. I want the columns to be alpha??? There could be some special format or sumation happening prior to getting the excel file. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
Repeating Rows and Columns on each page of print out | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |