ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I delete data in a cell without deleting formula? (https://www.excelbanter.com/excel-worksheet-functions/184460-how-do-i-delete-data-cell-without-deleting-formula.html)

tripy April 20th 08 10:44 PM

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.

Gord Dibben April 20th 08 11:06 PM

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.



David Biddulph[_2_] April 20th 08 11:07 PM

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.




[email protected] July 31st 15 03:16 PM

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

Auric__ July 31st 15 05:58 PM

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.

[email protected] September 5th 16 05:52 AM

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.

[email protected] June 18th 20 10:21 PM

how do I delete data in a cell without deleting formula?
 
I’m replying to a post from 4 years ago, replying to a post from 5 years ago, about a post from 12 years ago...

Auric__ June 19th 20 11:07 PM

how do I delete data in a cell without deleting formula?
 
ecomreed05 wrote:

I=E2=80=99m replying to a post from 4 years ago, replying to a post from
5 = years ago, about a post from 12 years ago...


....with absolutely no context whatsoever. The only reason this even caught my
attention is because it references my post in this thread. You idiots are a
waste of oxygen.

--
This is the most disturbing conversation I've ever had.

Michael Kilts September 20th 20 08:06 PM

how do I delete data in a cell without deleting formula?
 
I've just Subscribed to this thread, to watch it continually unfold for the next 20+ years.

Please, continue.

Tim Paine January 1st 21 11:27 AM

how do I delete data in a cell without deleting formula?
 
Follow these steps to manually delete data in a cell

Press F5. Excel displays the Go To dialog box.
Click the Special button. Excel displays the Go To Special dialog box
Select the Constants radio button. The four check boxes under the Formulas option then become available. (This can be a bit confusing. Why Microsoft made the Constants radio button control some check boxes under a different radio button is not immediately clear.)
Make sure that all the check boxes under the Formulas radio button are selected. (They should be selected by default.)
Click OK. Excel selects all the constants (cells that don't contain formulas) in the worksheet.
Press the Del key.

I hope this helps!
Tim Paine


All times are GMT +1. The time now is 09:47 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com