(Msg. 1) Posted: Wed Nov 04, 2009 3:38 am
Post subject: I need to delete the values in some cells, Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
but I want to leave the formulas in the cells intact. Can this be
done?
Thanks for any help
(Msg. 2) Posted: Wed Nov 04, 2009 8:16 am
Post subject: Re: I need to delete the values in some cells, [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Skip wrote:
> but I want to leave the formulas in the cells intact. Can this be
> done?
> Thanks for any help
Maybe this is what you want. Select the entire range of cells.
Edit / Go To / Special... / Constants / OK / Delete
(Msg. 3) Posted: Fri Nov 06, 2009 7:02 am
Post subject: Re: I need to delete the values in some cells, [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Nov 4, 9:16 am, Glenn <addr... DeleteThis @not.valid> wrote:
> Skip wrote:
> > but I want to leave the formulas in the cells intact. Can this be
> > done?
> > Thanks for any help
>
> Maybe this is what you want. Select the entire range of cells.
>
> Edit / Go To / Special... / Constants / OK /Delete
>
> If not, provide more details.
Glenn< I tried your idea, no luck.
I got a no cell selected box.
Skip
(Msg. 4) Posted: Fri Nov 06, 2009 9:10 am
Post subject: Re: I need to delete the values in some cells, [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Skip wrote:
> On Nov 4, 9:16 am, Glenn <addr... DeleteThis @not.valid> wrote:
>> Skip wrote:
>>> but I want to leave the formulas in the cells intact. Can this be
>>> done?
>>> Thanks for any help
>> Maybe this is what you want. Select the entire range of cells.
>>
>> Edit / Go To / Special... / Constants / OK /Delete
>>
>> If not, provide more details.
>
> Glenn< I tried your idea, no luck.
> I got a no cell selected box.
> Skip
>
(Msg. 5) Posted: Fri Nov 06, 2009 11:11 am
Post subject: Re: I need to delete the values in some cells, [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
> >> Maybe this is what you want. Select the entire range of cells.
>
> >> Edit / Go To / Special... / Constants / OK /Delete
>
> > Glenn< I tried your idea, no luck.
> > I got a no cell selected box.
> > Skip
>
> Then try my other suggestion.-
(Msg. 6) Posted: Fri Nov 06, 2009 1:26 pm
Post subject: Re: I need to delete the values in some cells, [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Skip wrote:
>>>> Maybe this is what you want. Select the entire range of cells.
>>>> Edit / Go To / Special... / Constants / OK /Delete
>>> Glenn< I tried your idea, no luck.
>>> I got a no cell selected box.
>>> Skip
>> Then try my other suggestion.-
>
> I am sorry, what is your other idea?
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office