Picture only in footer of last page?
 

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?

Picture only in footer of last page?
 

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?

"Al" wrote:

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?

Picture only in footer of last page?
 

Hi,

This is not possible.

Challa Prabhu

"Al" wrote:

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?

Picture only in footer of last page?
 

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.

Al wrote:

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?

--

Dave Peterson

Picture only in footer of last page?
 

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

"Dave Peterson" wrote:

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.

Al wrote:

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?

--

Dave Peterson