Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy excel workbook to new workbook without data
Have an excel workbook with multiple work sheets, need to copy all formulas,
styles, layouts, etc. to new workbook without the data in the original workbook? Do I need to create the work sheets and names prior to copying? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy excel workbook to new workbook without data
save the workbook with a new name, then clear all constants in all sheets
and you have your copy. "Omnitool" wrote in message ... Have an excel workbook with multiple work sheets, need to copy all formulas, styles, layouts, etc. to new workbook without the data in the original workbook? Do I need to create the work sheets and names prior to copying? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy excel workbook to new workbook without data
Can I clear the constants collectively in each sheet with out effecting the
formulas or style? "Bob Umlas" wrote: save the workbook with a new name, then clear all constants in all sheets and you have your copy. "Omnitool" wrote in message ... Have an excel workbook with multiple work sheets, need to copy all formulas, styles, layouts, etc. to new workbook without the data in the original workbook? Do I need to create the work sheets and names prior to copying? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy excel workbook to new workbook without data
Sure,
Edit/Go To/ Special/Constants/OK Hit delete Beege "Omnitool" wrote in message ... Can I clear the constants collectively in each sheet with out effecting the formulas or style? "Bob Umlas" wrote: save the workbook with a new name, then clear all constants in all sheets and you have your copy. "Omnitool" wrote in message ... Have an excel workbook with multiple work sheets, need to copy all formulas, styles, layouts, etc. to new workbook without the data in the original workbook? Do I need to create the work sheets and names prior to copying? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
What's the simplest way to copy data from another workbook | Excel Worksheet Functions |