ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   tab names are wrong when printing custom footers (using [&tab] ) (https://www.excelbanter.com/excel-worksheet-functions/265089-tab-names-wrong-when-printing-custom-footers-using-%5B-tab%5D.html)

S Hartman

tab names are wrong when printing custom footers (using [&tab] )
 
I am printing alot of charts for one spreadsheet that contains many tabs. I
would like each page printed to have the name of the tab, so I did the
following: clicked -page setup, -header/footer --Custom Footer, i clicked on
"& [Tab]" for the name of the tab to be printed on the footer for that
page. I get additional (incorrect) information after the tab name. Is
there a way to correct this other than manually keying in the name of the
each tab into the custom footer section?

nadine

tab names are wrong when printing custom footers (using [&tab] )
 
Try using Excel's Detect and Repair feature under the Help menu. It sounds
as though there's a slight bug in your program.

"S Hartman" wrote:

I am printing alot of charts for one spreadsheet that contains many tabs. I
would like each page printed to have the name of the tab, so I did the
following: clicked -page setup, -header/footer --Custom Footer, i clicked on
"& [Tab]" for the name of the tab to be printed on the footer for that
page. I get additional (incorrect) information after the tab name. Is
there a way to correct this other than manually keying in the name of the
each tab into the custom footer section?



All times are GMT +1. The time now is 02:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com