Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I rename columns in Excel 2003?
How do I rename columns in Excel 2003?
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I rename columns in Excel 2003?
Columns are either assigned letters:
column A or numbers: column 1 You can make a meaningful name in two ways: 1. use the first row as a column header and put your names in there 2. assign a Defined Name to the column - this will allow you to used =SUM(costs) instead of =SUM(A:A) -- Gary''s Student - gsnu200825 "chimala" wrote: How do I rename columns in Excel 2003? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I rename columns in Excel 2003?
What do you mean rename them? They are assigned column letters (or numbers
if R1C1 style) by Excel. You could turn off column headings and put your preferred heading in row 1, but the column will still be column C etc. -- __________________________________ HTH Bob "chimala" wrote in message ... How do I rename columns in Excel 2003? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I rename columns in Excel 2003?
The columns names are by default you can change them to R1C1 style but you
cannot rename them. In case you wish to put your own names then select Row 1 of the column and name them as desired. In case you wish to put R1C1 reference style then go to ToolsOptionsGeneral Tab and check the box of R1C1 reference styleok. By doing this you will see that the column name will change to numbers like 1,2,3 etc -- Thanks Suleman Peerzade "chimala" wrote: How do I rename columns in Excel 2003? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I rename the column letters a,b,c etc. in excel 2003 | Excel Worksheet Functions | |||
Need to rename table columns in excel from a query | Excel Worksheet Functions | |||
Rename Columns | New Users to Excel | |||
In Excel, how do I rename the gray rows/columns (1,2,3/A,B,C)? | Excel Discussion (Misc queries) | |||
how do you rename columns? | Excel Worksheet Functions |