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 / December 2007

Tip: Looking for answers? Try searching our database.

How do I put a heading even with a column?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Stressing out - 14 Dec 2007 15:26 GMT
Hello
I am looking to add company names as a header but even with columns.
Any idea how I might be able to do this
Gord Dibben - 14 Dec 2007 18:14 GMT
Maybe File>Page Setup>Sheet>Rows to repeat at top?

Place a company name in each column across row1

Gord Dibben  MS Excel MVP

>Hello
> I am looking to add company names as a header but even with columns.
>Any idea how I might be able to do this
Stressing out - 14 Dec 2007 18:38 GMT
I will try that Thank you!

> Maybe File>Page Setup>Sheet>Rows to repeat at top?
>
[quoted text clipped - 5 lines]
> > I am looking to add company names as a header but even with columns.
> >Any idea how I might be able to do this
Stressing out - 14 Dec 2007 21:16 GMT
I appreciate your help but this did not work. Thanks for trying

> Maybe File>Page Setup>Sheet>Rows to repeat at top?
>
[quoted text clipped - 5 lines]
> > I am looking to add company names as a header but even with columns.
> >Any idea how I might be able to do this
David McRitchie - 15 Dec 2007 02:58 GMT
You have no control over margins for page headers.
What you can do is use the first few rows for your
header,  put company name in row1
put normal column headers  in row 2
Use  repeat rows:     $2:$2
see
 Headings for Columns, and Page Numbering
  http://www.mvps.org/dmcritchie/excel/headcols.htm

Signature

HTH,
David McRitchie,  Microsoft MVP -- Excel
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm

>I appreciate your help but this did not work. Thanks for trying
>
[quoted text clipped - 7 lines]
>> > I am looking to add company names as a header but even with columns.
>> >Any idea how I might be able to do this
Gord Dibben - 15 Dec 2007 17:28 GMT
Perhaps some more details on what you want would be in order.

"did not work" is not very descriptive.

Gord

>I appreciate your help but this did not work. Thanks for trying
>
[quoted text clipped - 7 lines]
>> > I am looking to add company names as a header but even with columns.
>> >Any idea how I might be able to do this

Rate this thread:






 
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.