| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Copy header/footers in Excel 2003
How do I copy header text/formatting from one sheet to all others in an Excel
2003 workbook? I know there are products (VB Utilities) that I can buy, but I cannot instal something I buy and bruing from home at work. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Copy header/footers in Excel 2003
Bob
Group the sheets Hold either Ctrl (Non-contiguous) or shift (Contiguous) keys down while clicking a sheet tab (You will see [Group] in the application title bar. Now most things you do to one selected sheet will be done to the Group. To un-select, click on a non-selected tab or right click a selected one and select 'ungroup sheets' -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Bob Batchelder" <Bob wrote in message ... How do I copy header text/formatting from one sheet to all others in an Excel 2003 workbook? I know there are products (VB Utilities) that I can buy, but I cannot instal something I buy and bruing from home at work. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Copy header/footers in Excel 2003
Way to go, that did it! Thanks!
Bob "Nick Hodge" wrote: Bob Group the sheets Hold either Ctrl (Non-contiguous) or shift (Contiguous) keys down while clicking a sheet tab (You will see [Group] in the application title bar. Now most things you do to one selected sheet will be done to the Group. To un-select, click on a non-selected tab or right click a selected one and select 'ungroup sheets' -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Bob Batchelder" <Bob wrote in message ... How do I copy header text/formatting from one sheet to all others in an Excel 2003 workbook? I know there are products (VB Utilities) that I can buy, but I cannot instal something I buy and bruing from home at work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Excel 2003 - Copy Cell Reference | Excel Worksheet Functions | |||
| How do I open a Quattro Pro 7.0 file in Excel 2003 | Excel Discussion (Misc queries) | |||
| quattro pro converter Excel 2003 | New Users to Excel | |||
| Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Hybrid Mode
