H
hornless unicorn
how do i stop a footer from showing on the first page?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JMB
Check the answeres to this thread that asks the same question regarding a
header.
http://www.microsoft.com/office/com...6959&mid=967034fd-6b2e-4e93-8e42-5024cca16959
header.
http://www.microsoft.com/office/com...6959&mid=967034fd-6b2e-4e93-8e42-5024cca16959
G
Gord Dibben
You will have to use VBA or print page 1 as a separate print job with no Footer.
See Ron de Bruin's site for the VBA.
http://www.rondebruin.nl/print.htm#Header
Gord Dibben MS Excel MVP
See Ron de Bruin's site for the VBA.
http://www.rondebruin.nl/print.htm#Header
Gord Dibben MS Excel MVP
J
JMB
You could also set page 1 up on a separate worksheet w/o a footer. For the
tab w/pages 2-whatever, if you have page numbering you could use
&[page}+1 / &[pages}+1
to account for page one.
tab w/pages 2-whatever, if you have page numbering you could use
&[page}+1 / &[pages}+1
to account for page one.
R
Ron de Bruin
Not forget to add a space after the 1
&[Page]+1
See
http://support.microsoft.com/kb/48198/en-us
--
Regards Ron de Bruin
http://www.rondebruin.nl
&[Page]+1
See
http://support.microsoft.com/kb/48198/en-us
--
Regards Ron de Bruin
http://www.rondebruin.nl
JMB said:You could also set page 1 up on a separate worksheet w/o a footer. For the
tab w/pages 2-whatever, if you have page numbering you could use
&[page}+1 / &[pages}+1
to account for page one.
JMB said:Check the answeres to this thread that asks the same question regarding a
header.
http://www.microsoft.com/office/com...6959&mid=967034fd-6b2e-4e93-8e42-5024cca16959
J
JMB
My machine doesn't seem to care (once I properly change the braces } to
brackets ] )
Page&[Page]+1Of&[Pages]+1Pages
gives the result I expect (it needs spacing to make it readable, but the
lack of spaces didn't cause any other problems that I could see). I could
see a problem if you wanted a particular number printed in the footer (say a
1) so that Excel doesn't treat +1 as +11.
brackets ] )
Page&[Page]+1Of&[Pages]+1Pages
gives the result I expect (it needs spacing to make it readable, but the
lack of spaces didn't cause any other problems that I could see). I could
see a problem if you wanted a particular number printed in the footer (say a
1) so that Excel doesn't treat +1 as +11.
Ron de Bruin said:Not forget to add a space after the 1
&[Page]+1
See
http://support.microsoft.com/kb/48198/en-us
--
Regards Ron de Bruin
http://www.rondebruin.nl
JMB said:You could also set page 1 up on a separate worksheet w/o a footer. For the
tab w/pages 2-whatever, if you have page numbering you could use
&[page}+1 / &[pages}+1
to account for page one.
JMB said:Check the answeres to this thread that asks the same question regarding a
header.
http://www.microsoft.com/office/com...6959&mid=967034fd-6b2e-4e93-8e42-5024cca16959
:
how do i stop a footer from showing on the first page?
H
hornless unicorn
Thanks for the help, but WOW, that's ridiculously complicated.