| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a duplicate workbook without values
Save as a copy of the workbook.
Select all cells and F5SpecialConstants. Uncheck what you want to keep(like text for tiltles) and OK EditClear Contents. You may have to do some cleanup if there are any formulas referring to specific 2009 dates. Gord Dibben MS Excel MVP On Mon, 4 Jan 2010 13:55:01 -0800, JTG wrote: I created an inventory management workbook for 2009. I'd like to make one for 2010, complete with all headers and formulas but with the data fields blank. Can I copy the workbook without cell values, or do I have to start all over and create it from scratch? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a field to search and enter non duplicate data | Excel Discussion (Misc queries) | |||
| Eliminating Duplicate values on a large workbook | Excel Worksheet Functions | |||
| excel 2007 and creating duplicate rows in a spreadsheet? | Excel Discussion (Misc queries) | |||
| Creating graph from values in multiple tabs within workbook | Charts and Charting in Excel | |||
| Creating a macro to find duplicate names | Excel Discussion (Misc queries) | |||
Hybrid Mode
