Google Answers Logo
View Question
 
Q: Searching backward from the current row in Microsoft Excel ( Answered 5 out of 5 stars,   1 Comment )
Question  
Subject: Searching backward from the current row in Microsoft Excel
Category: Computers > Software
Asked by: carolw-ga
List Price: $50.00
Posted: 28 Sep 2004 12:51 PDT
Expires: 28 Oct 2004 12:51 PDT
Question ID: 407559
The "Find" function in Excel searches (in this order) the row below
your current cursor location and then starts at the beginning of the
sheet and goes forward to the next occurence of the search term.  I
need to search backward from my cursor location.  I have tried several
Excel tip sites and found nothing that addresses this.  Can you please
help me?
Answer  
Subject: Re: Searching backward from the current row in Microsoft Excel
Answered By: hummer-ga on 28 Sep 2004 13:26 PDT
Rated:5 out of 5 stars
 
Hi carolw,

Here you go - 

Hold down the "Shift" key while clicking on the "Find Next" button.
You can also limit your search by selecting a column(s) first and then
pressing shift + find next.

Hopefully, that is what you are looking for. If not, or if I
misunderstood your question, or if you have any questions, please post
a clarification request before closing/rating my answer and I'll be
happy to reply.

Thank you,
hummer

Search Strategy:

I searched Google Groups until I came upon this one:
http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&threadm=1272d01c415cf%24a585f610%24a601280a%40phx.gbl&rnum=6&prev=/groups%3Fq%3D%2522search%2520backwards%2522%2520%2520excel%26num%3D100%26hl%3Den%26lr%3D%26ie%3DUTF-8%26sa%3DN%26tab%3Dwg

My search terms:

"search backwards"  excel
"backward find"  excel
"backward search"  excel
backward find  excel
backward find function excel
search find excel backwards
carolw-ga rated this answer:5 out of 5 stars and gave an additional tip of: $5.00
Thank you so much!  I have searched quite a few Excel tip sites and
found nothing which helped me.  This is so simple, but you just don't
know how frustrated I've been.  You are a wonderful human being! (and
so fast)

Comments  
Subject: Re: Searching backward from the current row in Microsoft Excel
From: hummer-ga on 28 Sep 2004 15:33 PDT
 
Oh good, carolw, that's terrific, I'm so glad it's just what you need.
Thank you for your nice note, rating, and tip - you are very kind.
Sincerely, hummer

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy