ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I put a heading even with a column? (https://www.excelbanter.com/new-users-excel/169739-how-do-i-put-heading-even-column.html)

Stressing out

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

Gord Dibben

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



Stressing out[_2_]

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




Stressing out[_2_]

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




David McRitchie

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





Gord Dibben

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






All times are GMT +1. The time now is 01:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com