I have a peculiar problem in Excel after I create a ball, using Option/8. If I attempt to duplicate that ball to an adjacent cell by dragging, weird things happen.
Drag downward - no ball, instead the information from a cell in a totally unrelated spreadsheet.
Drag right - no ball, instead the information from the same cell in the totally unrelated spreadsheet.
Drag left - no ball, instead the information from a different cell in that same unrelated spreadsheet.
However, if I create a ball in two adjacent cells and then drag after highlighting the two cells, Excel will continue to copy the ball as expected.
Creation of a new spreadsheet doesn't change anything. It's always the same information from the same unrelated spreadsheet.
Curious, very curious. Poltergeist?
Last edited by ryck; 07/31/14 09:47 PM.