Information Required

A

Akash

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
 
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top