Column Headers

O

Otis

Hi,

I am trying to populate an Excel Worksheet from VB6. I can't figure out how
to put the column headers on the column header area of Excel. In other
words, I have columns 'First Name', 'Middle Name', etc. I want the area
where Excel names the columns 'A', 'B', etc. to have my headers. The best I
have been able to do is get them into the first row.

Also, is there a way to trim the number of columns so that no new blank
columns appear as the user horizontally scrolls past the last column with
data?

I hope this is clear. Thanks.

Otis
 
F

Frank Kabel

Hi
you can't change Excel's column headers. The best you can do (as you
have already discovered) is population row 1 and hiding Excel's column
headings
 
R

Ron de Bruin

Hi Otis

You can't replace them

But you can use window-Freeze Panes in the menubar
To freeze the first column and Row select cell b2 and do windows -Freeze Panes

You can put your own headers in the first row and column now

Under Tools -options -View uncheck row & column headers so
the default row and column headers are gone


You can hide the column you don't use

1 Select the first column next to your last column with data
2 CTRL-SHIFT-RIGHT ARROW
3 Right click on the selection and choose Hide
 
T

Tom Ogilvy

You can't change the labels for the columns or rows. (beyond the automatic
changes made by change the reference style).
 
O

Otis

Thanks Everyone. Its is almost as good to know when something can't be done
as is to know how something can be done.

Otis
 
Top