harleynana
MIS
In Excel when working with a spreadsheet that has numerous tabs, is there a way to make all heades/footers uniform other than entering this information individually in each tab?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
headers & footers in multiple worksheets 1
- Thread starter harleynana
- Start date
- Status
-
1
- #2
SkipVought
Programmer
Hi,
Select all the sheet-tabs you want to page setup identically. Then go set up the pages.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
Select all the sheet-tabs you want to page setup identically. Then go set up the pages.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
rcrecelius
Technical User
I never thought of that...that is definitely going to save me some time in the future!
Have a star on me
Have a star on me
- Status
Similar threads
- Locked
- Question