software

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

quot;Tom McGuirequot; lt;Tom gt; wrote in message
...
gt;I am a new user of MS Office Excel 2003. I know nothing about programming
gt; language. I already used the Help menu and couldn't find an answer. I
gt; was
gt; hoping to find among the menu choices a command that would let me replace
gt; (what I think are called) worksheet column headers (A, B, C, etc.) with
gt; names
gt; for the columns (Box, Remarks, Amount, etc.).
gt;
gt; I want to do this so I can print a worksheet in which column header names
gt; (rather than letters) appear at the top of each printed sheet. If all I
gt; can
gt; do is name a column by naming a range of cells within the worksheet, then
gt; the
gt; 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 -gt; Page Setup -gt; Sheet and complete teh section under print
titles

quot;Don Guillettquot; wrote:

gt; No can do. However you can put your headers in the first row and hide the
gt; rows/columns
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Tom McGuirequot; lt;Tom gt; wrote in message
gt; ...
gt; gt;I am a new user of MS Office Excel 2003. I know nothing about programming
gt; gt; language. I already used the Help menu and couldn't find an answer. I
gt; gt; was
gt; gt; hoping to find among the menu choices a command that would let me replace
gt; gt; (what I think are called) worksheet column headers (A, B, C, etc.) with
gt; gt; names
gt; gt; for the columns (Box, Remarks, Amount, etc.).
gt; gt;
gt; gt; I want to do this so I can print a worksheet in which column header names
gt; gt; (rather than letters) appear at the top of each printed sheet. If all I
gt; gt; can
gt; gt; do is name a column by naming a range of cells within the worksheet, then
gt; gt; the
gt; gt; name of the column only appears on the first printed page.
gt;
gt;
gt;

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

quot;Don Guillettquot; wrote:

gt; No can do. However you can put your headers in the first row and hide the
gt; rows/columns
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Tom McGuirequot; lt;Tom gt; wrote in message
gt; ...
gt; gt;I am a new user of MS Office Excel 2003. I know nothing about programming
gt; gt; language. I already used the Help menu and couldn't find an answer. I
gt; gt; was
gt; gt; hoping to find among the menu choices a command that would let me replace
gt; gt; (what I think are called) worksheet column headers (A, B, C, etc.) with
gt; gt; names
gt; gt; for the columns (Box, Remarks, Amount, etc.).
gt; gt;
gt; gt; I want to do this so I can print a worksheet in which column header names
gt; gt; (rather than letters) appear at the top of each printed sheet. If all I
gt; gt; can
gt; gt; do is name a column by naming a range of cells within the worksheet, then
gt; gt; the
gt; gt; name of the column only appears on the first printed page.
gt;
gt;
gt;

Thank you very much!!! It works!

McGuire

quot;Bald Eagle 49quot; wrote:

gt; As Don says put your headers in the first row. To print your headers on each
gt; page to FILE -gt; Page Setup -gt; Sheet and complete teh section under print
gt; titles
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt; gt; No can do. However you can put your headers in the first row and hide the
gt; gt; rows/columns
gt; gt;
gt; gt; --
gt; gt; Don Guillett
gt; gt; SalesAid Software
gt; gt;
gt; gt; quot;Tom McGuirequot; lt;Tom gt; wrote in message
gt; gt; ...
gt; gt; gt;I am a new user of MS Office Excel 2003. I know nothing about programming
gt; gt; gt; language. I already used the Help menu and couldn't find an answer. I
gt; gt; gt; was
gt; gt; gt; hoping to find among the menu choices a command that would let me replace
gt; gt; gt; (what I think are called) worksheet column headers (A, B, C, etc.) with
gt; gt; gt; names
gt; gt; gt; for the columns (Box, Remarks, Amount, etc.).
gt; gt; gt;
gt; gt; gt; I want to do this so I can print a worksheet in which column header names
gt; gt; gt; (rather than letters) appear at the top of each printed sheet. If all I
gt; gt; gt; can
gt; gt; gt; do is name a column by naming a range of cells within the worksheet, then
gt; gt; gt; the
gt; gt; gt; name of the column only appears on the first printed page.
gt; gt;
gt; gt;
gt; gt;