Help with Excel... problems pasting in search field

Discussion in 'MacBook Air' started by AKshanmar, Apr 13, 2014.

  1. AKshanmar macrumors newbie

    Apr 13, 2014
    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!
  2. campyguy macrumors 68040

    Mar 21, 2014
    Portland / Seattle
    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...
  3. AKshanmar thread starter macrumors newbie

    Apr 13, 2014
    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.

Share This Page