#1
|
|||
|
|||
when press enter, cell value rolls to zero
I copy a cell value from one worksheet (it is a sum formula). I paste the value into a different sheet in the same workbook. If I arrow out of the cell or click in a different cell, all is well, but if I hit return, the next cell down is selected and the value in the target cell goes to zero. If I return to the target cell and press return, the value stays.
I've never seen this behavior before. Excel 365. |
#2
|
||||
|
||||
Did you try pressing the Esc key to close the prompt "Select Destination...." before you hit enter?
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Starting Excel message Cell(press ESC to cancel) (x%) | Nednil | Excel | 0 | 10-06-2017 02:57 PM |
Mail Merging labels for paper rolls in Word 2007 | blackystrat | Mail Merge | 1 | 12-24-2015 03:21 AM |
text box appears after I press enter/try to write in bullet form | topgunitsme | Word | 1 | 08-13-2014 03:26 PM |
how to enter what i want in cell | tasuooooo | Excel | 4 | 07-23-2012 05:45 AM |
Highlighted text won't delete - when I press enter | Gague | Word | 2 | 07-09-2010 12:53 PM |