Formatting a pivot worksheet to display a string at the end!

  • Thread starter Thread starter matpj
  • Start date Start date
M

matpj

Hi there,

I have created several worksheets using the 'Show Pages' function, but
now need to add a bit of blurb underneath each of the pivot tables.

I was thinking of doing this in the Page Footer, but this will be
displayed on every page - and some worksheets will span several pages.

Can anyone tell me if there is an easy and quick way of adding some
text to the end of the pivot tables in every worksheet (there are 50
worksheets!)

thanks in advance,
Matt
 
Hi,
Have a look at this page of Ron's Debruin's
http://www.rondebruin.nl/print.htm#Header, about 3/4's of the way dow
is a section titled "Do not print Header or Footer on all pages". Thi
may give you a good starting point.

hth,
Rob Brockett,
NZ
Always learning & the best way to learn is to experience..
 
Back
Top