Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

AKshanmar

macrumors newbie
Original poster
Apr 13, 2014
2
0
My life is spreadsheets... but my computer is apparently tired of them. I am searching 13 digit ISBN #s.

When I first open the spreadsheet, I can paste a ISBN in the search field and it will find it in the spread sheet like expected. But then after a few successful searches, it starts pasting the search item, wherever I was last in the spreadsheet. I can clear the search field, and the same thing happens. Meanwhile, I can type an item into the search field, and it works just fine. I am using "command v", but the same thing happens using paste from the file menu. I can reboot my computer, and then it works for awhile again...

Thanks for any suggestions!
 
By your comment I'm assuming the "Quick Search" field in the upper right of the Standard Toolbar. IMO that feature isn't meant for heavy use - it's buggy, has been since Office 2003/4.

My tip for productivity - use the "Find" Command to search for redundant work. There's no "why" or "why doesn't it" with me - that's what works in Excel for me on Mac and Windows platforms. Or, use Automator...
 
Awesome... that does the trick.

Who needs "whys" when something works!

My husband was daring to blame it on my macbook air, and said I should get a real computer... apparently that was his "why".

Thanks for taking the time to answer.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.