Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can we change the alpha No. display in the column caption bar

Status
Not open for further replies.
coolago

coolago

Programmer
Apr 24, 2001
22
CN
Now it will show A, B, C, D ... in the column caption bar, but we need to change them, e.g.
display "EquipName" instead of "A" in the first column,
display "ModelNo." instead of "B" in the second column,
display "Description" indtead of "C" in the third column,
and so on.

By the way, this is an excel activex component embedded in the equip maintenance page in our b/s system, and from now we have found that the split/freeze function cannt meet our needs.

Could u please tell me how can we change the alpha number in the column caption bar? Is there any macro to do this? Any suggestion will be appreciated.
Thank you very much for your so kind help!
Vincent
----------------

If u think u can, then u can!
 
Sort by date Sort by votes
You mean, you want to display EquipName, replacing A,B etc?? or do you simply want to hide the ABC, 1,2,3 borders?

stupid.gif
 
Upvote 0 Downvote
Thank TonyU!
I mean the previous one, i.e. replacing A,B,C,D with our own captions e.g. "SID", "NAME", "AGE", "ADDRESS", and so on.
Could u please tell me how to implement this?
Thanks again!

Vincent
---------------------
If u think u can, then u can!
 
Upvote 0 Downvote
'cept in this case....unfortunately, you can't. The closest you can get is to goto Tools>Options>View and untick Column headers. The A,b,c will now disappear and you can use ROW 1 for your headers - just format them to be grey and no-one will know the difference ;-)

Rgds, Geoff
Si hoc legere scis, nimis eruditionis habes
Want the best answers to your questions ? - then read me baby one more time - faq222-2244
 
Upvote 0 Downvote
Thank xlbo. Thank you all!
We have tried this method. Now the problem is that ROW 1 will be out of view when click the vertical scroll bar. But if you freeze ROW 1 then you cannt click the horizontal scroll bar to view the last some columns.

How can we? Following is a source code example of our equip maintenance web page.
Thanks again!
Vincent

------------------------------------------------------------
<html>
<head>
<title>Equipment Maintenance</title>
</head>
<p align=&quot;center&quot;>
<form action=&quot;detail_excelUI_save.do&quot; name=&quot;excelForm&quot; method=&quot;POST&quot;>
<span style=&quot;font-size: 14px&quot;>
<font color=&quot;#000080&quot;>Detail Equip Maintenance - Shenzhen Telecommunication Ltd. 2003-06-30
</font></span>&nbsp;
<input type=&quot;submit&quot; value=&quot;Save&quot; name=&quot;btnSave&quot; class=&quot;button&quot; onclick=&quot;onSubmit();&quot;>
<hr color=&quot;#000080&quot; size=1>
<div align=&quot;center&quot;>
<input type=&quot;text&quot; name=&quot;title&quot; size=&quot;113&quot; style=&quot;border-style: solid&quot; readonly=&quot;true&quot;>
<object classid=&quot;clsid:0002E510-0000-0000-C000-000000000046&quot; id=&quot;sheet&quot; width=&quot;800&quot; height=&quot;500&quot;>
<param name=&quot;HTMLURL&quot; value>
<param name=&quot;HTMLData&quot; value=&quot;<html xmlns:x=&quot;urn:schemas-microsoft-com:eek:ffice:excel&quot;
xmlns=&quot;
<head>
<style type=&quot;text/css&quot;>
<!--tr
{mso-height-source:auto;}
td
{white-space:nowrap;}
.wc0C53AD4
{white-space:nowrap;
font-family:ËÎÌå;
mso-number-format:General;
font-size:auto;
font-weight:auto;
font-style:auto;
text-decoration:auto;
mso-background-source:auto;
mso-pattern:auto;
mso-color-source:auto;
text-align:general;
vertical-align:bottom;
border-top:none;
border-left:none;
border-right:none;
border-bottom:none;
mso-protection:unlocked;}
-->
</style>
</head>

<body>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:OWCVersion>9.0.0.2710</x:OWCVersion>
<x:Label Style='border-top:solid .5pt silver;border-left:solid .5pt silver;
border-right:solid .5pt silver;border-bottom:solid .5pt silver'>
<x:Caption>Microsoft Office Spreadsheet</x:Caption>
</x:Label>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions>
<x:Selected/>
<x:Height>7620</x:Height>
<x:Width>15240</x:Width>
<x:TopRowVisible>0</x:TopRowVisible>
<x:LeftColumnVisible>0</x:LeftColumnVisible>
<x:protectContents>False</x:protectContents>
<x:DefaultRowHeight>210</x:DefaultRowHeight>
<x:StandardWidth>2389</x:StandardWidth>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:MaxHeight>80%</x:MaxHeight>
<x:MaxWidth>80%</x:MaxWidth>
</x:ExcelWorkbook>
</xml><![endif]-->

<table class=wc0C53AD4 x:str>
<col width=&quot;56&quot;>
<tr height=&quot;14&quot;>
<td></td>
</tr>
</table>

</body>

</html>
&quot;>
<param name=&quot;DataType&quot; value=&quot;HTMLDATA&quot;>
<param name=&quot;AutoFit&quot; value=&quot;0&quot;>
<param name=&quot;DisplayColHeaders&quot; value=&quot;-1&quot;>
<param name=&quot;DisplayGridlines&quot; value=&quot;-1&quot;>
<param name=&quot;DisplayHorizontalScrollBar&quot; value=&quot;-1&quot;>
<param name=&quot;DisplayRowHeaders&quot; value=&quot;-1&quot;>
<param name=&quot;DisplayTitleBar&quot; value=&quot;0&quot;>
<param name=&quot;DisplayToolbar&quot; value=&quot;0&quot;>
<param name=&quot;DisplayVerticalScrollBar&quot; value=&quot;-1&quot;>
<param name=&quot;EnableAutoCalculate&quot; value=&quot;-1&quot;>
<param name=&quot;EnableEvents&quot; value=&quot;-1&quot;>
<param name=&quot;MoveAfterReturn&quot; value=&quot;-1&quot;>
<param name=&quot;MoveAfterReturnDirection&quot; value=&quot;0&quot;>
<param name=&quot;RightToLeft&quot; value=&quot;0&quot;>
<param name=&quot;ViewableRange&quot; value=&quot;1:65536&quot;>
</object>
</div>
<input type=&quot;hidden&quot; name=&quot;data&quot; value=&quot;&quot;>
<input type=&quot;hidden&quot; name=&quot;columnCount&quot; value=&quot;&quot;>
<input type=&quot;hidden&quot; name=&quot;rowCount&quot; value=&quot;&quot;>
<script language=&quot;javascript&quot;>
excelForm.sheet.CSVData = &quot;Shenzhen,Import,China,Huawei,C08,2002,1,2,3\nShenzhen,Import,USA,Motolola,C09,2002,1,2,3\nShenzhen,Import,Fenland,Nokia,C10,2002,1,2,3\nShenzhen,Import,China,Huawei,C11,2002,1,2,3\nShenzhen,Import,China,Huawei,C12,2002,1,2,3\nShenzhen,Import,China,Huawei,C13,2002,1,2,3\nShenzhen,Import,China,Huawei,C14,2002,1,2,3\nShenzhen,Import,China,Huawei,C15,2002,1,2,3\nShenzhen,Import,China,Huawei,C16,2002,1,2,3\nShenzhen,Import,China,Huawei,C17,2002,1,2,3\nShenzhen,Import,China,Huawei,C18,2002,1,2,3\nShenzhen,Import,China,Huawei,C19,2002,1,2,3\n&quot;;
excelForm.title.value = &quot;Location(A)|ImportMethod(B)|Country(C)|Company(D)|Model(E)|Year(F)|SCP Capacity(G)|SSP Capacity(H)|Remark1(I)|Remark2(I)|Remark3(I)&quot;;
var range = &quot;A:&quot;+ (String.fromCharCode(12+64));
excelForm.sheet.ViewableRange = range;
</script>
</form>
<p align=&quot;center&quot;>
<a href=&quot;ListDetail.do&quot;>Back</a>
</body>
</html>
 
Upvote 0 Downvote
Please clarify :
&quot;you cannt click the horizontal scroll bar to view the last some columns&quot;

I can freeze row 1 and then use the scroll bars to go left and right still.....

Rgds, Geoff
Si hoc legere scis, nimis eruditionis habes
Want the best answers to your questions ? - then read me baby one more time - faq222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
1K
Andrzejek
Andrzejek
Cpreston
  • Locked
  • Question
Trim Multiple items in one column
Replies
2
Views
162
Andrzejek
Andrzejek
titanif
  • Locked
  • Question
Office 365- Spill A Table Column Into Another Tables Column
Replies
1
Views
125
SkipVought
S
ladyck3
  • Locked
  • Question
Excel 365 - Auto-Populating a cell from date in the next cell. 2
Replies
9
Views
181
ladyck3
ladyck3
GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
466
combo
combo

Part and Inventory Search

Sponsor

Back
Top