Is there a way to get rid of the space designated for a header/footer completely so as to use that space in the document? While I can expand it beyond the default space by filling it in, I cannot find a way to contract it to nil height.
Is there a way to set up a document so that the header/footer appears only on the first page. I know I can do that by creating a new section but I want to create a template that will insert the header on the first page only and the document goes to the next page automatically without inserting the header on subsequent pages.
click first page
go to page set up
click different first page
now put header in
it will only be on first page
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks for that. Any suggestions as to how to get rid of the header altogether?
What do you mean: "get rid of the header"? just don't enter anything in the header and set your top margin to suit.
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
While you can set the margin at the top, I cannot find a way to reduce the header width to zero, even if it is blank. This is what I want to accomplish.
Maybe I don't get it.
If you're not using a header and pull the top margin all the way up, the space for the header and the space for the body will overlap. But since you're not using the header, that does not matter, does it? So there's really no need to reduce the header to zero.
What do you want to accomplish?
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
How do you highlight specific cells for a rolling header?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks