Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Can a row (or column) be used in a Excel file footer?
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. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Can a row (or column) be used in a Excel file footer?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel footer to look like Word footer? | Excel Discussion (Misc queries) | |||
Create header/footer txt file and link to Excel worksheets | Excel Discussion (Misc queries) | |||
File name in the footer/header | Excel Discussion (Misc queries) | |||
Link footer of one file to cells in another file | Excel Discussion (Misc queries) | |||
Path and File Name to Footer | Excel Discussion (Misc queries) |