| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
header footer
How do I go about formatting all my worksheets with the same header/footer
without having to do each seperately? I have 25 workbooks with 12 worksheets each, all I want is for each sheet to have a header image. How can I do this? |
|
#2
|
|||
|
|||
|
Hi CW
Right Click one of the sheets and select "Select All Sheets" form the pop up menu. Now set your header/ footer. This header/ footer will be applied to all the worksheets at once. Thanks Karthik Bhat Bangalore |
|
#3
|
|||
|
|||
|
Keep in mind that after you "SELECT ALL SHEETS", you have to do your page
setup without going into print preview first. Do it from the FILE, PAGE SETUP toolbar. "Karthik" wrote: Hi CW Right Click one of the sheets and select "Select All Sheets" form the pop up menu. Now set your header/ footer. This header/ footer will be applied to all the worksheets at once. Thanks Karthik Bhat Bangalore |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
header footer
"Christine - HCVT" wrote: Keep in mind that after you "SELECT ALL SHEETS", you have to do your page setup without going into print preview first. Do it from the FILE, PAGE SETUP toolbar. "Karthik" wrote: Hi CW Right Click one of the sheets and select "Select All Sheets" form the pop up menu. Now set your header/ footer. This header/ footer will be applied to all the worksheets at once. Thanks Karthik Bhat Bangalore |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Give multiple charts on a worksheet/workbook same header or footer | Excel Discussion (Misc queries) | |||
| Give multiple charts on a worksheet/workbook same header or footer | Charts and Charting in Excel | |||
| How do I hide the header and footer on page 1 in Excel? | Excel Discussion (Misc queries) | |||
| Custom Header and Footer | Excel Discussion (Misc queries) | |||
| How to insert a picture in the Footer (not the Header) in Excel 20 | Excel Worksheet Functions | |||
Linear Mode
