Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I insert a header only once in excel with many tabs
I have a file with many tabs and I want to change the footers/headers in each
tab, but I want to make a global search and replace instead of manually going to each tab. Is there a way to do that? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I insert a header only once in excel with many tabs
Select all the sheets (right-click a sheet tab, select All Sheets), use Page
Setup make whatever change you want -- you're doing it to all the sheets. Then right-click a sheet tab & Ungroup Sheets. Bob Umlas Excel MVP "koshur_butteh" wrote in message ... I have a file with many tabs and I want to change the footers/headers in each tab, but I want to make a global search and replace instead of manually going to each tab. Is there a way to do that? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I insert a header only once in excel with many tabs
Thank you ... this works great.
"Bob Umlas" wrote: Select all the sheets (right-click a sheet tab, select All Sheets), use Page Setup make whatever change you want -- you're doing it to all the sheets. Then right-click a sheet tab & Ungroup Sheets. Bob Umlas Excel MVP "koshur_butteh" wrote in message ... I have a file with many tabs and I want to change the footers/headers in each tab, but I want to make a global search and replace instead of manually going to each tab. Is there a way to do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set up single Header/Footer for all tabs in Excel Workbook. | Excel Worksheet Functions | |||
How do I insert a link to a cell in a header in Excel? | Excel Discussion (Misc queries) | |||
Excel - option to select the same header for mutliple tabs | Setting up and Configuration of Excel | |||
How do I insert a header on an existing Excel sheet? | Excel Discussion (Misc queries) | |||
How to insert a picture in the Footer (not the Header) in Excel 20 | Excel Worksheet Functions |