Can I change Column Header Names?

Z

zameer_india

Hi All..

Can I change Coulmn Header Names... What I mean to say that , We Have
Generally Column Names A, B, C, D, ... I would like to Change these
names what ever I Want.. Any help would be Appreciate...

Thanx ina Advance...


Zameer ahmed syed
email : [email protected]
: [email protected]
 
D

DM Unseen

You can simulate this by disabeling the column&row headings,and typing
your own column headers in the first row and the split the window on
the first row and the do freeze panes. Throw in a few colors to make it
look good and presto, almost as good as real column headers.

DM Unseen
 
Z

zameer_india

Thanx all for kind replies....

i am thinking U all people just assuming that I am doing some offic
work . But in fact I got one problem during testing in WinRunner.

Here it is Scenario..................


Actually I am Doing "Data Driven Testing " as a part of my work. I
Data Driven Testing When Ever I select Script , WinRunner Generates on
Default.xls Excel Sheet for me .. In that Excel Sheet I have found Th
Column Names (which are variable names in my programming). No Proble
with this testing.

Actually i want to make an excel sheet as like as generated b
WinRunner so that i call this test manually . But, I faced problem her
so far. as I mentioned earlier
Generally In each and every excel sheet , the default columns name
were "A,B,C,D,.... " , If i change this column names to my Variabl
names then defintiely I will solve my problem.


In this view only , I asked this Question in this forum.. but it seem
to be little bit awkward . Still I am wating fo
answers/replies/suggestions or any other help. Any help would b
appreciated.

Thanx in Advance,

[email protected]
 
M

mangesh_yadav

In the auto-generated shete, what is the address of the first cell
(upper-left cell). You can see the address in the name range above.

Alternatively, you can use the cell function
=CELL("address",A1)

But instead of copying the above fourmula to your auto-generated sheet,
do the following. Go to the Insert > Function. Select All. Then select
the CELL functions. Enter first argument as "address", in the second
box (reference), select the upper-leftmost cell.

Does this return $A$1, or does it return the second row.

Mangesh
 
M

mangesh_yadav

Another thing you could try is:
Open the auto-generated sheet. Click on Tools > Options > View Tab. I
the windows option, see if the checkbox Row & Column Headers is checke
or not.

Manges
 
Z

zameer_india

Thanx Mangesh for Ur Kind and Interesting Reply...

Look at the Auto Generated Worksheet. Throuhg Attachments files .. what
ever the options U gave me , those were not present in Auto Generated
Worksheet.

what to do ?...


Thanx in advance,


Zameer


+-------------------------------------------------------------------+
|Filename: To Excel Forum.doc |
|Download: http://www.excelforum.com/attachment.php?postid=3561 |
+-------------------------------------------------------------------+
 
M

mangesh_yadav

Assuming that after performing this test:
Open the auto-generated sheet. Click on Tools > Options > View Tab. In
the windows option, see if the checkbox Row & Column Headers is checked
or not.
Click to expand...

You found that in your auto-generated sheet, the above option box was
not checked. This means that these sheets have rows and columns
(probably 1st in both cases) modified to look like headers.

To generate your own sheet similar to this, simply enter the required
headers in the top row for each column, and similarly for rows. If you
want to keep the rows numbered as 1, 2, 3, and so on, then put the
numebrs in the first column for each row till the end.

Now go to Tools > Options > View tab. And uncheck the box: Row & Column
Headers.

You may give a background color to the header names similar to the
actuals ones.

Mangesh
 
Top