| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy of Header-Footer in Excel
Is it possible to repeat the same "Header-Footer" contents in all the
worksheets (say 5) in a opened file. I am using Excel 2003. At present, its very boring and time consuming for same "header- footer" content to copy in each worksheet for display. Sincerely Raj |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy of Header-Footer in Excel
Before entering header/footer, press and hold CTRL key and select the sheets
you want the 'same' header/footer to occur. After selecting all of your sheets that you will be entering for, then enter your header a -- John C "raj74" wrote: Is it possible to repeat the same "Header-Footer" contents in all the worksheets (say 5) in a opened file. I am using Excel 2003. At present, its very boring and time consuming for same "header- footer" content to copy in each worksheet for display. Sincerely Raj |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy of Header-Footer in Excel
Lots of print settings can be set if you group the worksheets first.
Select the first worksheet tab. Then ctrl-click on subsequent worksheet tabs. Then do your page setup stuff. This may change more than you want, so test the results. And after you're done, ungroup the worksheets. Rightclick on one of the selected worksheet tabs and select "ungroup sheets". Otherwise, you could be making changes to each of the grouped worksheets for things you don't want! raj74 wrote: Is it possible to repeat the same "Header-Footer" contents in all the worksheets (say 5) in a opened file. I am using Excel 2003. At present, its very boring and time consuming for same "header- footer" content to copy in each worksheet for display. Sincerely Raj -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy of Header-Footer in Excel
Thanks John & Dave for your reply.
Sincerely Raj "Dave Peterson" wrote: Lots of print settings can be set if you group the worksheets first. Select the first worksheet tab. Then ctrl-click on subsequent worksheet tabs. Then do your page setup stuff. This may change more than you want, so test the results. And after you're done, ungroup the worksheets. Rightclick on one of the selected worksheet tabs and select "ungroup sheets". Otherwise, you could be making changes to each of the grouped worksheets for things you don't want! raj74 wrote: Is it possible to repeat the same "Header-Footer" contents in all the worksheets (say 5) in a opened file. I am using Excel 2003. At present, its very boring and time consuming for same "header- footer" content to copy in each worksheet for display. Sincerely Raj -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a header and footer to multiple worksheets? | Setting up and Configuration of Excel | |||
| Copy Header/Footer to Retain Formatting | Excel Discussion (Misc queries) | |||
| How do I copy the print settings, including header and footer fro. | Excel Discussion (Misc queries) | |||
| Allow header/footer to copy to other worksheets in 1 spreadsheet. | Excel Worksheet Functions | |||
| Is it possible to copy a header/footer from one worksheet to anoth | Excel Discussion (Misc queries) | |||
Linear Mode
