Help with Excel... problems pasting in search field

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

  1. AKshanmar macrumors newbie

    Joined:
    Apr 13, 2014
    #1
    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 68030

    Joined:
    Mar 21, 2014
    Location:
    Portland / Seattle
    #2
    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

    Joined:
    Apr 13, 2014
    #3
    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