Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting worksheets, existing and new, in existing workbooks
Hi, not sure if my 1st message posted ok, but in any case, my question
relates to what the best method would be to format each worksheet the same (i.e. same page layout, orientation, header) in any given workbook that has information already saved on it, and have the same formatting for when a new worksheet is added. I have severak workbooks that require their own specific editing, thus i need to avoid a mass default of specific parameters. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting worksheets, existing and new, in existing workbooks
Select the sheets to format (click on the first sheet and shift click on the
last sheet to select contiguous worksheets, or click on the first sheet and Control + Click to select non-contiguous sheets) to turn Group Mode on and then add the formatting as needed as well as any common formulas. Formatting and formulas are placed in all selected worksheets. When finished right click on any selected worksheet tab and selet UNGROUP SHEETS. -- Kevin Backmann "G. Dagger" wrote: Hi, not sure if my 1st message posted ok, but in any case, my question relates to what the best method would be to format each worksheet the same (i.e. same page layout, orientation, header) in any given workbook that has information already saved on it, and have the same formatting for when a new worksheet is added. I have severak workbooks that require their own specific editing, thus i need to avoid a mass default of specific parameters. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting worksheets, existing and new, in existing workbooks
Thanks Kevin, just one more thing however, when i add a new worksheet the
default parameters are still there. Is there anyway for a new worksheet to reflect the changes automatically? "Kevin B" wrote: Select the sheets to format (click on the first sheet and shift click on the last sheet to select contiguous worksheets, or click on the first sheet and Control + Click to select non-contiguous sheets) to turn Group Mode on and then add the formatting as needed as well as any common formulas. Formatting and formulas are placed in all selected worksheets. When finished right click on any selected worksheet tab and selet UNGROUP SHEETS. -- Kevin Backmann "G. Dagger" wrote: Hi, not sure if my 1st message posted ok, but in any case, my question relates to what the best method would be to format each worksheet the same (i.e. same page layout, orientation, header) in any given workbook that has information already saved on it, and have the same formatting for when a new worksheet is added. I have severak workbooks that require their own specific editing, thus i need to avoid a mass default of specific parameters. Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting worksheets, existing and new, in existing workbooks
You could keep a blank worksheet fully formatted w/formulas in place and use
it as a template. When you need a new worksheet just make a copy of the the template sheet by right clicking on the tab and selecting move or copy. Click the check box that says MAKE COPY and you're set to go. -- Kevin Backmann "G. Dagger" wrote: Thanks Kevin, just one more thing however, when i add a new worksheet the default parameters are still there. Is there anyway for a new worksheet to reflect the changes automatically? "Kevin B" wrote: Select the sheets to format (click on the first sheet and shift click on the last sheet to select contiguous worksheets, or click on the first sheet and Control + Click to select non-contiguous sheets) to turn Group Mode on and then add the formatting as needed as well as any common formulas. Formatting and formulas are placed in all selected worksheets. When finished right click on any selected worksheet tab and selet UNGROUP SHEETS. -- Kevin Backmann "G. Dagger" wrote: Hi, not sure if my 1st message posted ok, but in any case, my question relates to what the best method would be to format each worksheet the same (i.e. same page layout, orientation, header) in any given workbook that has information already saved on it, and have the same formatting for when a new worksheet is added. I have severak workbooks that require their own specific editing, thus i need to avoid a mass default of specific parameters. Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting worksheets, existing and new, in existing workbooks
See your first post for another response.
Gord Dibben MS Excel MVP On Mon, 7 Jan 2008 09:08:00 -0800, G. Dagger wrote: Thanks Kevin, just one more thing however, when i add a new worksheet the default parameters are still there. Is there anyway for a new worksheet to reflect the changes automatically? "Kevin B" wrote: Select the sheets to format (click on the first sheet and shift click on the last sheet to select contiguous worksheets, or click on the first sheet and Control + Click to select non-contiguous sheets) to turn Group Mode on and then add the formatting as needed as well as any common formulas. Formatting and formulas are placed in all selected worksheets. When finished right click on any selected worksheet tab and selet UNGROUP SHEETS. -- Kevin Backmann "G. Dagger" wrote: Hi, not sure if my 1st message posted ok, but in any case, my question relates to what the best method would be to format each worksheet the same (i.e. same page layout, orientation, header) in any given workbook that has information already saved on it, and have the same formatting for when a new worksheet is added. I have severak workbooks that require their own specific editing, thus i need to avoid a mass default of specific parameters. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formuals not working in existing workbooks | Excel Worksheet Functions | |||
download existing spreadsheets into another existing spreadsheet | Excel Discussion (Misc queries) | |||
Template changes to existing workbooks | Excel Worksheet Functions | |||
inserting sheets into existing workbooks w/o external references | Excel Worksheet Functions | |||
How can I get existing Excel workbooks to open in separate windows | Excel Worksheet Functions |