Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i make a footer on second page only?
excel worksheet is more than one page. I would like the footer on the second
page of that worksheet. How can I do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i make a footer on second page only?
Record a macro while you change the footer for the first page, print just that
page, then change the header and print the rest of the pages. Then when you need this kind of printing, rerun that macro. If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Betty wrote: excel worksheet is more than one page. I would like the footer on the second page of that worksheet. How can I do this? -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i make a footer on second page only?
To OP
If you do go to Ron de Bruin's site see this page for code to print footers on only some pages. http://www.rondebruin.nl/print.htm#not Gord Dibben MS Excel MVP On Tue, 01 Sep 2009 16:41:23 -0500, Dave Peterson wrote: Record a macro while you change the footer for the first page, print just that page, then change the header and print the rest of the pages. Then when you need this kind of printing, rerun that macro. If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Betty wrote: excel worksheet is more than one page. I would like the footer on the second page of that worksheet. How can I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format page number in excel footer to start at a specific page # | Excel Discussion (Misc queries) | |||
make footer longer | Excel Discussion (Misc queries) | |||
print footer on every page (Totals on every page) | Excel Discussion (Misc queries) | |||
header and footer on every page except the first page? | Excel Discussion (Misc queries) | |||
Make the default always with a Footer | Excel Discussion (Misc queries) |