| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel -Cannot global Header change
My excel workgroup consists of 15 work sheet. I cannot make changes in
the header globally. I have to go to individual work sheet and make the change. What can I do to correct thsi setup. Thanks. Rag742 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel -Cannot global Header change
the only way I know how to do this would be to write a macro. Youcan access
the headers and footers with macros. "Rag742" wrote: My excel workgroup consists of 15 work sheet. I cannot make changes in the header globally. I have to go to individual work sheet and make the change. What can I do to correct thsi setup. Thanks. Rag742 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel -Cannot global Header change
Is a "workgroup" a single workbook?
Are the 15 worksheets in that single workbook? If so, select a sheet then right-click on the sheet tab and "select all sheets". Set up the header on the active sheet and will be done to all sheets. DO NOT FORGET to right-click and "ungroup" the sheets when done. Gord Dibben MS Excel MVP On 14 Feb 2007 09:19:31 -0800, "Rag742" wrote: My excel workgroup consists of 15 work sheet. I cannot make changes in the header globally. I have to go to individual work sheet and make the change. What can I do to correct thsi setup. Thanks. Rag742 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel -Cannot global Header change
On Feb 14, 1:18 pm, Gord Dibben <gorddibbATshawDOTca wrote:
Is a "workgroup" a single workbook? Are the 15 worksheets in that single workbook? If so, select a sheet then right-click on the sheet tab and "select all sheets". Set up the header on the active sheet and will be done to all sheets. DO NOT FORGET to right-click and "ungroup" the sheets when done. Gord Dibben MS Excel MVP On 14 Feb 2007 09:19:31 -0800, "Rag742" wrote: My excel workgroup consists of 15 work sheet. I cannot make changes in the header globally. I have to go to individual work sheet and make the change. What can I do to correct thsi setup. Thanks. Rag742 Thank You. It works Rag742 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel -Cannot global Header change
Happy to hear you're sorted out.
Appreciate the feedback. On 14 Feb 2007 13:25:44 -0800, "Rag742" wrote: On Feb 14, 1:18 pm, Gord Dibben <gorddibbATshawDOTca wrote: Is a "workgroup" a single workbook? Are the 15 worksheets in that single workbook? If so, select a sheet then right-click on the sheet tab and "select all sheets". Set up the header on the active sheet and will be done to all sheets. DO NOT FORGET to right-click and "ungroup" the sheets when done. Gord Dibben MS Excel MVP On 14 Feb 2007 09:19:31 -0800, "Rag742" wrote: My excel workgroup consists of 15 work sheet. I cannot make changes in the header globally. I have to go to individual work sheet and make the change. What can I do to correct thsi setup. Thanks. Rag742 Thank You. It works Rag742 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I perform a global change within/across Excel workbooks? | Excel Discussion (Misc queries) | |||
| Range name: Change from sheet specific to global | Excel Discussion (Misc queries) | |||
| Global change to cell values | Excel Discussion (Misc queries) | |||
| How do I do a global change from uppercase to lowercase? | Excel Discussion (Misc queries) | |||
| Set up global custom header and footer in Excel worksheets? | Excel Worksheet Functions | |||
Hybrid Mode
