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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Thank you very much!!! It works!

McGuire

Bald Eagle 49 said:
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
Click to expand...
 
Back
Top