Re: Copying cell values once and then making them static

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hmm, I usually use ctrl-v to paste.. But still, I want it to happen
automaticly, something like "=permanent(blah!C33) but unfortunately there is
no such function (as far as I know)

Thanks anyway!
"bj" <bj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:77C9D166-5FBE-451A-9EB1-15B5E29E61C0@xxxxxxxxxxxxxxxx
>I would customize your tool bar, Remove the standard Paste button and add
> the paste values button. You could still paste from the drop down menu,
>
> If you only want to do this sometimes you could put together a quick menu
> to
> trade the two buttons as needed.
> "Tsjah" wrote:
>
>> Hello,
>>
>> Is it possible to copy values from one cell in to another (automaticly)
>> and
>> then just storing the copied value, not the formula? This is for changing
>> numbers I would like to store dayly. Up to now I just do a copy, paste
>> special, values, but obviously I tend to forget..
>>
>> Thanks a lot in advance,
>>
>> Mike
>>
>>
>>


.

Relevant Pages

  • Re: Storing the 306
    ... Elder wrote: ... stand for more than a couple of weeks before; is there anything I should do either before storing (hmm, it hasn't been driven since before Christmas if I'm honest), or before I start to drive it again? ... the hy-ab. ...
    (uk.rec.cars.modifications)
  • Re: Simple "If" Function - HELP
    ... "And" function to hook up all the three criterias. ... Hmm, interesting. ... So, if I have understood you correctly, your cell will ... I have Range A1 to A850 containing alphabets. ...
    (microsoft.public.excel)
  • Re: Copy paste hyperlink
    ... Now when I copy the cell down the range, ... The HYPERLINK() is a simple formula, ... Ctrl-C Ctrl-V operation over the range I was attempting to insert it on. ...
    (microsoft.public.excel)
  • Re: Comma Woes
    ... hmm actually when I open up a new excel sheet and in C1 I put in 4,6 and ... past that formula in cell D1 it returns #!VALUE! ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Torture and American television
    ... Matt Ion wrote: ... "The Cell" and had to shut them both down after about 10 minutes. ... Hmm, ... I thought the story could've been better--also, casting J-Lo in it didn't help either. ...
    (rec.arts.sf.tv.babylon5.moderated)