Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 125
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table cutting information of a part of the information ASR Excel Discussion (Misc queries) 1 November 5th 09 02:09 PM
VB help required adeel via OfficeKB.com Excel Discussion (Misc queries) 2 July 3rd 09 03:04 PM
Required information in a cell Steve New Users to Excel 4 November 28th 07 01:22 PM
Required Information Mike J Excel Discussion (Misc queries) 1 May 22nd 06 05:57 AM
Can't quite get this syntax to bring in the required information. Sharlene England Excel Programming 1 November 29th 03 08:47 AM


All times are GMT +1. The time now is 05:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"