ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Information Required (https://www.excelbanter.com/excel-programming/382957-information-required.html)

Akash

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


Gary''s Student

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




All times are GMT +1. The time now is 01:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com