Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Information Required
Hi,
I just wanted to know that can we change the name of the column. By Default in Excel we have, A.... B.... C..... D... 1 2 3 4 5 6 7 If i want to name the Colum A as Akash, is it possible, I want Akash Should come in place of "A", Bikash should come in place of "B" Awaiting for your help. Thanks in Advance. Regards Akash |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Information Required
The column "names" are either letters or numbers. But you have two extra
options: 1. In cell A1 enter: Akash In cell B1 enter: Bikash etc. When you print the worksheet the titles will print identifying the columns by name. 2. Select column A and pull-down: Insert Name Define and enter Akash as the name With this option you can use the name in a formula: =SUM(Akash) same as =SUM(A:A) -- Gary''s Student gsnu200705 "Akash" wrote: Hi, I just wanted to know that can we change the name of the column. By Default in Excel we have, A.... B.... C..... D... 1 2 3 4 5 6 7 If i want to name the Colum A as Akash, is it possible, I want Akash Should come in place of "A", Bikash should come in place of "B" Awaiting for your help. Thanks in Advance. Regards Akash |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table cutting information of a part of the information | Excel Discussion (Misc queries) | |||
VB help required | Excel Discussion (Misc queries) | |||
Required information in a cell | New Users to Excel | |||
Required Information | Excel Discussion (Misc queries) | |||
Can't quite get this syntax to bring in the required information. | Excel Programming |