Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tom McGuire - 18 Jan 2006 16:56 GMT
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.
Don Guillett - 18 Jan 2006 17:07 GMT
No can do. However you can put your headers in the first row and hide the
rows/columns

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>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
[quoted text clipped - 10 lines]
> the
> name of the column only appears on the first printed page.
Bald Eagle 49 - 18 Jan 2006 17:31 GMT
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

> No can do. However you can put your headers in the first row and hide the
> rows/columns
[quoted text clipped - 13 lines]
> > the
> > name of the column only appears on the first printed page.
Tom McGuire - 18 Jan 2006 17:39 GMT
Thank you very much!!!  It works!

McGuire

> 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
[quoted text clipped - 17 lines]
> > > the
> > > name of the column only appears on the first printed page.
Tom McGuire - 18 Jan 2006 17:39 GMT
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

> No can do. However you can put your headers in the first row and hide the
> rows/columns
[quoted text clipped - 13 lines]
> > the
> > name of the column only appears on the first printed page.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.