How can I create headers without having them occupy Row #1 of my spreadsheet?

Go to the View menu and choose Header/Footer. This will bring up
a dialog that will allow you to insert page headers and footers.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"mollymay" wrote in message
...
How can I create headers without having them occupy Row #1 of
my spreadsheet?

If you are talking about titles for each column, you cannot create them without
using row 1.

If talking about headers when printing, see Chip's response.


Gord Dibben MS Excel MVP

On Mon, 24 Apr 2006 11:50:02 -0700, mollymay
wrote:

How can I create headers without having them occupy Row #1 of my spreadsheet?

I see now that my question was poorly framed. I should have stated that I
wanted to create column titles without using row #1. Chip did not understand
my question because I used the herm header which, of course, is not what I
meant. thanks for clarifying my question and giving me a definitive answer.

"Gord Dibben" wrote:

If you are talking about titles for each column, you cannot create them without
using row 1.

If talking about headers when printing, see Chip's response.


Gord Dibben MS Excel MVP

On Mon, 24 Apr 2006 11:50:02 -0700, mollymay
wrote:

How can I create headers without having them occupy Row #1 of my spreadsheet?