| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I delete data in a cell without deleting formula?
after adding data to a formulatted cell on a worksheet, i save as, and then
use the previous worksheet and delete data to start another worksheet. when doing this I also delete the formulas, which I don't want to do- go to question. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I delete data in a cell without deleting formula?
First, copy the worksheet then on copied sheet hit F5SpecialConstants
Uncheck what you want to keep, like "text" for titles and OK EditClearContents or just hit the delete key. Gord Dibben MS Excel MVP On Sun, 20 Apr 2008 14:44:00 -0700, tripy wrote: after adding data to a formulatted cell on a worksheet, i save as, and then use the previous worksheet and delete data to start another worksheet. when doing this I also delete the formulas, which I don't want to do- go to question. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I delete data in a cell without deleting formula?
A cell contains either formula or data. It can't contain both.
-- David Biddulph "tripy" wrote in message ... after adding data to a formulatted cell on a worksheet, i save as, and then use the previous worksheet and delete data to start another worksheet. when doing this I also delete the formulas, which I don't want to do- go to question. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I delete data in a cell without deleting formula?
On Sunday, April 20, 2008 at 11:07:25 PM UTC+1, David Biddulph wrote:
A cell contains either formula or data. It can't contain both. -- David Biddulph "tripy" wrote in message ... after adding data to a formulatted cell on a worksheet, i save as, and then use the previous worksheet and delete data to start another worksheet. when doing this I also delete the formulas, which I don't want to do- go to question. That is rubbish David |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I delete data in a cell without deleting formula?
mattsteel101 wrote:
On Sunday, April 20, 2008 at 11:07:25 PM UTC+1, David Biddulph wrote: A cell contains either formula or data. It can't contain both. That is rubbish David You're replying to a post from 7 years ago. -- I look at my life and it just seems so depressing that I'm not sure if I was born or if Morrissey sang me into existence. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I delete data in a cell without deleting formula?
On Friday, July 31, 2015 at 12:59:57 PM UTC-4, Auric__ wrote:
mattsteel101 wrote: On Sunday, April 20, 2008 at 11:07:25 PM UTC+1, David Biddulph wrote: A cell contains either formula or data. It can't contain both. That is rubbish David You're replying to a post from 7 years ago. -- I look at my life and it just seems so depressing that I'm not sure if I was born or if Morrissey sang me into existence. I'm replying to a post from a year ago.. about a post from 7 years prior.. just for the hell of it. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I delete data in a cell without deleting formula?
Im replying to a post from 4 years ago, replying to a post from 5 years ago, about a post from 12 years ago...
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to delete cell values withour deleting cell formulae | Excel Discussion (Misc queries) | |||
| Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
| I can't delete a cell without deleting a row | Excel Discussion (Misc queries) | |||
| how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
| how do I delete data from a worksheet without deleting the formul. | Excel Discussion (Misc queries) | |||
Hybrid Mode
