| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I transfer formulas but not the information?
I have a spreadsheet that consists of 8 worksheets, each page is formulated to transfer accumulated data to another sheet. It is for statistics for a club. My questions is how do I transfer the worksheets and the formulas without transfering the data? I have tried to save as a new spreadsheet and delete the numbers but that also deletes the formulas? Help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I transfer formulas but not the information?
Try
Ctrl+G Special Constant and then heit delete. this will clear only the values not the formulas. HTH "Confused Assistant" wrote: I have a spreadsheet that consists of 8 worksheets, each page is formulated to transfer accumulated data to another sheet. It is for statistics for a club. My questions is how do I transfer the worksheets and the formulas without transfering the data? I have tried to save as a new spreadsheet and delete the numbers but that also deletes the formulas? Help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Switching Information | Excel Discussion (Misc queries) | |||
| Transfer information into Excel spreadsheet | Excel Discussion (Misc queries) | |||
| Printing formulas | Excel Discussion (Misc queries) | |||
| copy worksheet to a new workbook with formulas .... but new file not point to old one | Excel Discussion (Misc queries) | |||
| Putting Excel formatting and/or formulas into CSV file | Excel Discussion (Misc queries) | |||
Linear Mode
