Help with Excel... problems pasting in search field

[AKshanmar]

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!

 

[campyguy]

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...

 

[AKshanmar]

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.