I am trying to identify IF there is a way to have a row always shown on the
Excel print, but on the footer. This is due to using a Pivot-table format
for the actual report/data view.

Many thanks for reading this question - I would be very greatful if anyone
can suggest a way round this?

At present I have used the Page Setup to always include the relevant Rows
(currently A:F) at the top of the page. I do not particularly like this as
A:F is actually notes (or guidance) on how the numbers have been calculated
therefore would look tidier if at the bottom of the printed sheet.

You can do this using a little vb script. Check the link below for more info.

http://support.microsoft.com/default.aspx/kb/273028

Hope this helps

Sean.

"Tracey" wrote:

I am trying to identify IF there is a way to have a row always shown on the
Excel print, but on the footer. This is due to using a Pivot-table format
for the actual report/data view.

Many thanks for reading this question - I would be very greatful if anyone
can suggest a way round this?

At present I have used the Page Setup to always include the relevant Rows
(currently A:F) at the top of the page. I do not particularly like this as
A:F is actually notes (or guidance) on how the numbers have been calculated
therefore would look tidier if at the bottom of the printed sheet.