An open community 
of Macintosh users,
for Macintosh users.

FineTunedMac Dashboard widget now available! Download Here

Topic Options
#30692 - 07/31/14 02:44 PM Excel - Option Asterisk Oddity
ryck Offline


Registered: 08/04/09
Loc: Okanagan Valley
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?


Edited by ryck (07/31/14 02:47 PM)
_________________________
ryck

iMac (Retina 5K, 27", 2017), 3.4 GHz Intel Core i5, 8GB RAM, 2400 MHz DDR4
OS High Sierra 10.13.6
Canon MX710 Printer
Epson Perfection V500 Photo Scanner
Time Machine on 320GB OWC Mercury OTG Pro
Super Duper on 500GB OWC Mercury OTG Pro

Top
#30693 - 07/31/14 04:02 PM Re: Excel - Option Asterisk Oddity [Re: ryck]
artie505 Online


Registered: 08/04/09
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

Top
#30694 - 08/01/14 02:51 AM Re: Excel - Option Asterisk Oddity [Re: artie505]
ryck Offline


Registered: 08/04/09
Loc: Okanagan Valley
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

iMac (Retina 5K, 27", 2017), 3.4 GHz Intel Core i5, 8GB RAM, 2400 MHz DDR4
OS High Sierra 10.13.6
Canon MX710 Printer
Epson Perfection V500 Photo Scanner
Time Machine on 320GB OWC Mercury OTG Pro
Super Duper on 500GB OWC Mercury OTG Pro

Top
#30716 - 08/01/14 05:55 PM Re: Excel - Option Asterisk Oddity [Re: ryck]
joemikeb Offline
Moderator

Registered: 08/04/09
Loc: Fort Worth, Texas
You would probably get more answers on the Microsoft Office for Mac forums.
_________________________
joemikeb • moderator

Top
#30720 - 08/02/14 02:23 AM Re: Excel - Option Asterisk Oddity [Re: joemikeb]
ryck Offline


Registered: 08/04/09
Loc: Okanagan Valley
Yes, you may be right. I'll check them out and if I learn anything I'll post here.
_________________________
ryck

iMac (Retina 5K, 27", 2017), 3.4 GHz Intel Core i5, 8GB RAM, 2400 MHz DDR4
OS High Sierra 10.13.6
Canon MX710 Printer
Epson Perfection V500 Photo Scanner
Time Machine on 320GB OWC Mercury OTG Pro
Super Duper on 500GB OWC Mercury OTG Pro

Top

Moderator:  alternaut, dianne, dkmarsh