2006-12-17 03:22:09 · 4 answers · asked by Anonymous in Computers & Internet ➔ Other - Computers
It has to be a macro. So if you are not bothered with VBA, I am ok to send you a code sample telling you what to do.
You can e-mail me from Y Q/A
2006-12-17 03:36:50 · answer #1 · answered by Anonymous · 0⤊ 0⤋
If your headers and footers are custom, you can do the follow steps.
Copy the header from your source worksheet, select all worksheets (press on the Ctrl, click on the worksheets). Click View, Header and Footer, Click Custom and paste what you have copied earlier. Do the same for the Footer.
2006-12-17 05:17:50 · answer #2 · answered by Del S 2 · 0⤊ 0⤋
Copy your headers and footers to a notepad.
Select all your spreadsheet tab and set up your headers and footers at the same time.
To setup your headers and footers, just go to menu "View=>Headers and Footers".
Paste your headers and footers from the notepad or type in new headers and footers.
2006-12-17 03:34:56 · answer #3 · answered by ttrantan 1 · 0⤊ 0⤋
My sister had to help me with this once, (I don't remember how we did it),I wasn't able to get ahold of her, but I found this website, I hope it helps...
http://www.exceltip.com/excel_tips/Excel_Printing/12.html
2006-12-17 03:41:24 · answer #4 · answered by Milkaholic 6 · 0⤊ 0⤋