Picture only in footer of last page?

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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?
 
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.
 
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

Back
Top