Losing Focus on Cell

marka87uk

Board Regular
Joined
Mar 24, 2007
Messages
247
Hi,

When working on different spreadsheets, I sometimes have to alt-tab to other windows to, for instance, remember the next part of a number I'm entering into a cell.

Sometimes I can do this and carry on typing, other times, when I tab back to Excel, the data I was in the middle of entering has been entered so I have to edit the cell to carry on entering the data.

Where can I change this option, presuming there is one? :)
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

dglnz

Board Regular
Joined
Apr 30, 2007
Messages
52
Not trying to be silly _but_ why can't you copy the data from the original app then click / move to a cell and then paste data in?

I've done it heaps of times myself.

regards

dave.

ps and this is from a SUN OS via emulation on winxp to excel 2003!
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi Mark

You can do this if you're entering a formula (ie cell starts with =) but if it is simply text you're enetering then the cell will lose focus and the text will be entered. I don't think there is a setting to amend this.
 

marka87uk

Board Regular
Joined
Mar 24, 2007
Messages
247
Thanks for the replies - I'll have to have a closer look into it - and the reason why I can't copy it is because sometimes the number or text may be in an image for example, or on an iSeries.
 

Forum statistics

Threads
1,181,606
Messages
5,930,866
Members
436,764
Latest member
avalladarez

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top