|
Excel - Option Asterisk Oddity
|
Joined: Aug 2009
Likes: 14
|
OP
Joined: Aug 2009
Likes: 14 |
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.
ryck
"What Were Once Vices Are Now Habits" The Doobie Brothers
iMac (Retina 5K, 27", 2020), 3.8 GHz 8 Core Intel Core i7, 8GB RAM, 2667 MHz DDR4 OS Ventura 13.6.3 Canon Pixma TR 8520 Printer Epson Perfection V500 Photo Scanner c/w VueScan software TM on 1TB LaCie USB-C
|
|
Re: Excel - Option Asterisk Oddity
|
Joined: Aug 2009
Likes: 15
|
Joined: Aug 2009
Likes: 15 |
I can't help you other than by suggesting that you post your version of Excel.
The new Great Equalizer is the SEND button.
In Memory of Harv: Those who can make you believe absurdities can make you commit atrocities. ~Voltaire
|
|
Re: Excel - Option Asterisk Oddity
|
Joined: Aug 2009
Likes: 14
|
OP
Joined: Aug 2009
Likes: 14 |
Of course, I should have thought of that.
Excel for Mac 2011 V 14.3.9 (131030)
And, an additional bit of background, the information from the unrelated spreadsheet is always from the same cell of the same records of that sheet.
ryck
"What Were Once Vices Are Now Habits" The Doobie Brothers
iMac (Retina 5K, 27", 2020), 3.8 GHz 8 Core Intel Core i7, 8GB RAM, 2667 MHz DDR4 OS Ventura 13.6.3 Canon Pixma TR 8520 Printer Epson Perfection V500 Photo Scanner c/w VueScan software TM on 1TB LaCie USB-C
|
|
Re: Excel - Option Asterisk Oddity
|
Joined: Aug 2009
Likes: 16
Moderator
|
Moderator
Joined: Aug 2009
Likes: 16 |
You would probably get more answers on the Microsoft Office for Mac forums.
If we knew what it was we were doing, it wouldn't be called research, would it?
— Albert Einstein
|
|
Re: Excel - Option Asterisk Oddity
|
Joined: Aug 2009
Likes: 14
|
OP
Joined: Aug 2009
Likes: 14 |
Yes, you may be right. I'll check them out and if I learn anything I'll post here.
ryck
"What Were Once Vices Are Now Habits" The Doobie Brothers
iMac (Retina 5K, 27", 2020), 3.8 GHz 8 Core Intel Core i7, 8GB RAM, 2667 MHz DDR4 OS Ventura 13.6.3 Canon Pixma TR 8520 Printer Epson Perfection V500 Photo Scanner c/w VueScan software TM on 1TB LaCie USB-C
|
|
|
|
|