Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default How do I put a heading even with a column?

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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default How do I put a heading even with a column?

Maybe FilePage SetupSheetRows to repeat at top?

Place a company name in each column across row1


Gord Dibben MS Excel MVP

On Fri, 14 Dec 2007 07:26:01 -0800, Stressing out <Stressing
wrote:

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


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default How do I put a heading even with a column?

I will try that Thank you!

"Gord Dibben" wrote:

Maybe FilePage SetupSheetRows to repeat at top?

Place a company name in each column across row1


Gord Dibben MS Excel MVP

On Fri, 14 Dec 2007 07:26:01 -0800, Stressing out <Stressing
wrote:

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



  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default How do I put a heading even with a column?

I appreciate your help but this did not work. Thanks for trying

"Gord Dibben" wrote:

Maybe FilePage SetupSheetRows to repeat at top?

Place a company name in each column across row1


Gord Dibben MS Excel MVP

On Fri, 14 Dec 2007 07:26:01 -0800, Stressing out <Stressing
wrote:

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



  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 903
Default How do I put a heading even with a column?

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

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


"Stressing out" wrote in message ...
I appreciate your help but this did not work. Thanks for trying

"Gord Dibben" wrote:

Maybe FilePage SetupSheetRows to repeat at top?

Place a company name in each column across row1


Gord Dibben MS Excel MVP

On Fri, 14 Dec 2007 07:26:01 -0800, Stressing out <Stressing
wrote:

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






  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default How do I put a heading even with a column?

Perhaps some more details on what you want would be in order.

"did not work" is not very descriptive.


Gord

On Fri, 14 Dec 2007 13:16:01 -0800, Stressing out
wrote:

I appreciate your help but this did not work. Thanks for trying

"Gord Dibben" wrote:

Maybe FilePage SetupSheetRows to repeat at top?

Place a company name in each column across row1


Gord Dibben MS Excel MVP

On Fri, 14 Dec 2007 07:26:01 -0800, Stressing out <Stressing
wrote:

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In a table produce an value by column heading and row heading naflan Excel Worksheet Functions 1 December 27th 05 05:18 PM
column heading rml Excel Discussion (Misc queries) 1 June 30th 05 04:15 AM
Need to put a name in the column heading windsorhartung Excel Discussion (Misc queries) 6 February 19th 05 06:36 AM
Renaming a column or heading? notanexpertinexcel Excel Worksheet Functions 1 January 25th 05 01:20 AM
How do I set up a column with a heading and a subheading? Chelle21 Excel Discussion (Misc queries) 1 November 29th 04 09:08 PM


All times are GMT +1. The time now is 12:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"