View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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