Continue Typing in Cell when Clicking Away
 

Hello
There is an option in excel that seems to randomly work and not work. What I
have to do is type large numbers into excel cells and I can't possibly
remember the entire number so I will click on the cell to type a few of them
then click back on the internet to get more of the number and then clicking
back on excel to continue typing it.
Sometimes I can continue typing but other times when I click on the web
browser the excel cell closes so when I click to continue typing it overrides
what is in there to begin with. So how can I keep it open so I can just click
back and forth?

Thanks!

Continue Typing in Cell when Clicking Away
 

Try selecting the number on the web page, press <Ctrl + C to copy the
selection and then paste it into the cell with Ctrl + V
--
Kevin Backmann


"Peter" wrote:

Hello
There is an option in excel that seems to randomly work and not work. What I
have to do is type large numbers into excel cells and I can't possibly
remember the entire number so I will click on the cell to type a few of them
then click back on the internet to get more of the number and then clicking
back on excel to continue typing it.
Sometimes I can continue typing but other times when I click on the web
browser the excel cell closes so when I click to continue typing it overrides
what is in there to begin with. So how can I keep it open so I can just click
back and forth?

Thanks!

Continue Typing in Cell when Clicking Away
 

Is it possible for you to copy the number from the Internet and paste it in
the cell you need?
--
JWeaver


"Peter" wrote:

Hello
There is an option in excel that seems to randomly work and not work. What I
have to do is type large numbers into excel cells and I can't possibly
remember the entire number so I will click on the cell to type a few of them
then click back on the internet to get more of the number and then clicking
back on excel to continue typing it.
Sometimes I can continue typing but other times when I click on the web
browser the excel cell closes so when I click to continue typing it overrides
what is in there to begin with. So how can I keep it open so I can just click
back and forth?

Thanks!

Continue Typing in Cell when Clicking Away
 

1. on the website, hi-light the big number and then CNTRL-c
2. click on the cell you want to fill
3. click in the formula bar and then CNTRL-v
--
Gary''s Student - gsnu200800


"Peter" wrote:

Hello
There is an option in excel that seems to randomly work and not work. What I
have to do is type large numbers into excel cells and I can't possibly
remember the entire number so I will click on the cell to type a few of them
then click back on the internet to get more of the number and then clicking
back on excel to continue typing it.
Sometimes I can continue typing but other times when I click on the web
browser the excel cell closes so when I click to continue typing it overrides
what is in there to begin with. So how can I keep it open so I can just click
back and forth?

Thanks!

Continue Typing in Cell when Clicking Away
 

We have formatting issues so it saves me time to do it by typing. It's weird
that this only works sometimes.

"JWeaver" wrote:

Is it possible for you to copy the number from the Internet and paste it in
the cell you need?
--
JWeaver


"Peter" wrote:

Hello
There is an option in excel that seems to randomly work and not work. What I
have to do is type large numbers into excel cells and I can't possibly
remember the entire number so I will click on the cell to type a few of them
then click back on the internet to get more of the number and then clicking
back on excel to continue typing it.
Sometimes I can continue typing but other times when I click on the web
browser the excel cell closes so when I click to continue typing it overrides
what is in there to begin with. So how can I keep it open so I can just click
back and forth?

Thanks!

Continue Typing in Cell when Clicking Away
 

It's hard to explain but copy and paste causes more problems than the other,
there has to be a way to make work because I've done it before in fact it
worked yesterday and it's not today.

"Gary''s Student" wrote:

1. on the website, hi-light the big number and then CNTRL-c
2. click on the cell you want to fill
3. click in the formula bar and then CNTRL-v
--
Gary''s Student - gsnu200800


"Peter" wrote:

Hello
There is an option in excel that seems to randomly work and not work. What I
have to do is type large numbers into excel cells and I can't possibly
remember the entire number so I will click on the cell to type a few of them
then click back on the internet to get more of the number and then clicking
back on excel to continue typing it.
Sometimes I can continue typing but other times when I click on the web
browser the excel cell closes so when I click to continue typing it overrides
what is in there to begin with. So how can I keep it open so I can just click
back and forth?

Thanks!

Continue Typing in Cell when Clicking Away
 

Just a little tip. If you copy something into Notepad, then select and copy
it again, it only copies the text and not the formatting.

"Peter" wrote:

Hello
There is an option in excel that seems to randomly work and not work. What I
have to do is type large numbers into excel cells and I can't possibly
remember the entire number so I will click on the cell to type a few of them
then click back on the internet to get more of the number and then clicking
back on excel to continue typing it.
Sometimes I can continue typing but other times when I click on the web
browser the excel cell closes so when I click to continue typing it overrides
what is in there to begin with. So how can I keep it open so I can just click
back and forth?

Thanks!

Continue Typing in Cell when Clicking Away
 

Pasting in the cell can get funny formats.
Pasting in the formula bar will avoid any changes to the format
--
Gary''s Student - gsnu200800


"Peter" wrote:

It's hard to explain but copy and paste causes more problems than the other,
there has to be a way to make work because I've done it before in fact it
worked yesterday and it's not today.

"Gary''s Student" wrote:

1. on the website, hi-light the big number and then CNTRL-c
2. click on the cell you want to fill
3. click in the formula bar and then CNTRL-v
--
Gary''s Student - gsnu200800


"Peter" wrote:

Hello
There is an option in excel that seems to randomly work and not work. What I
have to do is type large numbers into excel cells and I can't possibly
remember the entire number so I will click on the cell to type a few of them
then click back on the internet to get more of the number and then clicking
back on excel to continue typing it.
Sometimes I can continue typing but other times when I click on the web
browser the excel cell closes so when I click to continue typing it overrides
what is in there to begin with. So how can I keep it open so I can just click
back and forth?

Thanks!

Continue Typing in Cell when Clicking Away
 

Peter

So far none of the replies about copy/paste has addressed your question of
why the cell won't stay in Edit Mode when you switch to back to the Web
Page.

I cannot replicate the behaviour so this post won't be much help<g

I can type 12345 in a cell then switch to a web site or this post, go back
to Excel and continue typing in the cell.

Are you inadvertantly clicking on another cell during the process?


Gord Dibben MS Excel MVP

On Thu, 14 Aug 2008 12:37:01 -0700, Peter
wrote:

It's hard to explain but copy and paste causes more problems than the other,
there has to be a way to make work because I've done it before in fact it
worked yesterday and it's not today.

"Gary''s Student" wrote:

1. on the website, hi-light the big number and then CNTRL-c
2. click on the cell you want to fill
3. click in the formula bar and then CNTRL-v
--
Gary''s Student - gsnu200800


"Peter" wrote:

Hello
There is an option in excel that seems to randomly work and not work. What I
have to do is type large numbers into excel cells and I can't possibly
remember the entire number so I will click on the cell to type a few of them
then click back on the internet to get more of the number and then clicking
back on excel to continue typing it.
Sometimes I can continue typing but other times when I click on the web
browser the excel cell closes so when I click to continue typing it overrides
what is in there to begin with. So how can I keep it open so I can just click
back and forth?

Thanks!