Picture only in footer of last page?

G

Guest

Can I set up a picture in the footer such that it only appears in the last
page's footer?
Page Setup -> Custom Footer -> Insert picture gives me the picture in the
footer, but my spreadsheet runs to, say, three pages, and I only want the
picture to appear on page 3.
I'm using Excel 2003
Any ideas?
 
G

Guest

Sorry, any given worksheet only has one header/footer, so whatever you set up
in those areas appears in all physical pages printed from the sheet.
Header/footer setup in Excel is much less robust than in Word and no such
thing as a Section break on a sheet in Excel.

Perhaps just put the picture on the worksheet at the end of all data?
 
D

Dave Peterson

Maybe you could use a macro.

Print the first x pages without the picture and then print the last page with
the footer.

Ron de Bruin shares how to do this with text:
http://www.rondebruin.nl/print.htm#Header

You could modify the macro (record one to how to remove the picture and add the
picture) so it would work for you.
 
G

Guest

Thank you all for your replies....perhaps this is a feature that MS should
look at?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top