In Excel, how do I change worksheet headers (A,B) to names (Box)?

I am a new user of MS Office Excel 2003. I know nothing about programming
language. I already used the Help menu and couldn't find an answer. I was
hoping to find among the menu choices a command that would let me replace
(what I think are called) worksheet column headers (A, B, C, etc.) with names
for the columns (Box, Remarks, Amount, etc.).

I want to do this so I can print a worksheet in which column header names
(rather than letters) appear at the top of each printed sheet. If all I can
do is name a column by naming a range of cells within the worksheet, then the
name of the column only appears on the first printed page.

No can do. However you can put your headers in the first row and hide the
rows/columns

--
Don Guillett
SalesAid Software

"Tom McGuire" Tom wrote in message
...
I am a new user of MS Office Excel 2003. I know nothing about programming
language. I already used the Help menu and couldn't find an answer. I
was
hoping to find among the menu choices a command that would let me replace
(what I think are called) worksheet column headers (A, B, C, etc.) with
names
for the columns (Box, Remarks, Amount, etc.).

I want to do this so I can print a worksheet in which column header names
(rather than letters) appear at the top of each printed sheet. If all I
can
do is name a column by naming a range of cells within the worksheet, then
the
name of the column only appears on the first printed page.

As Don says put your headers in the first row. To print your headers on each
page to FILE - Page Setup - Sheet and complete teh section under print
titles

"Don Guillett" wrote:

No can do. However you can put your headers in the first row and hide the
rows/columns

--
Don Guillett
SalesAid Software

"Tom McGuire" Tom wrote in message
...
I am a new user of MS Office Excel 2003. I know nothing about programming
language. I already used the Help menu and couldn't find an answer. I
was
hoping to find among the menu choices a command that would let me replace
(what I think are called) worksheet column headers (A, B, C, etc.) with
names
for the columns (Box, Remarks, Amount, etc.).

I want to do this so I can print a worksheet in which column header names
(rather than letters) appear at the top of each printed sheet. If all I
can
do is name a column by naming a range of cells within the worksheet, then
the
name of the column only appears on the first printed page.

Thanks for the reply. I was afraid I couldn't do it, but Bald Eagle 49 told
me how to do what I wanted.

McGuire

"Don Guillett" wrote:

No can do. However you can put your headers in the first row and hide the
rows/columns

--
Don Guillett
SalesAid Software

"Tom McGuire" Tom wrote in message
...
I am a new user of MS Office Excel 2003. I know nothing about programming
language. I already used the Help menu and couldn't find an answer. I
was
hoping to find among the menu choices a command that would let me replace
(what I think are called) worksheet column headers (A, B, C, etc.) with
names
for the columns (Box, Remarks, Amount, etc.).

I want to do this so I can print a worksheet in which column header names
(rather than letters) appear at the top of each printed sheet. If all I
can
do is name a column by naming a range of cells within the worksheet, then
the
name of the column only appears on the first printed page.

Thank you very much!!! It works!

McGuire

"Bald Eagle 49" wrote:

As Don says put your headers in the first row. To print your headers on each
page to FILE - Page Setup - Sheet and complete teh section under print
titles

"Don Guillett" wrote:

No can do. However you can put your headers in the first row and hide the
rows/columns

--
Don Guillett
SalesAid Software

"Tom McGuire" Tom wrote in message
...
I am a new user of MS Office Excel 2003. I know nothing about programming
language. I already used the Help menu and couldn't find an answer. I
was
hoping to find among the menu choices a command that would let me replace
(what I think are called) worksheet column headers (A, B, C, etc.) with
names
for the columns (Box, Remarks, Amount, etc.).

I want to do this so I can print a worksheet in which column header names
(rather than letters) appear at the top of each printed sheet. If all I
can
do is name a column by naming a range of cells within the worksheet, then
the
name of the column only appears on the first printed page.