2

When you do a simple search in Excel, it seems to scan left to right proceeding down row by row. Is it possible to reverse this so that Excel instead searches right to left proceeded up row by row?

  • Are you just using Ctrl+F to search? If you are then it isn't possible. However, if you use VBA, you can use ".find" and you can change the direction to xlPrevious which will search backwards through a defined range – DavePenn Sep 9 '17 at 19:27
  • Thanks, @DavePenn. Yes, I'm using Ctrl+F. I don't use VBA. – A. Ro Sep 9 '17 at 22:38
  • This link may help you. mrexcel.com/forum/excel-questions/… – DavePenn Sep 10 '17 at 5:12
2

In the Find and Replace window, hit Shift+Enter instead of Enter to search backwards.

After you've hit Shift+Enter the first time, you can close the Find and Replace window and hit F4 to continue through to the next match up/left.

Conversely, you can simply hit Enter in the Find and Replace window to find the next match down/right and then Ctrl+Shift+F4 to repeat the action in reverse, thus moving up/left.

| improve this answer | |
  • 1
    Thanks so much! This is exactly what I was looking for. – A. Ro Sep 11 '17 at 20:10
0

You could potentially rotate the table 180° onto a new sheet using offset () and do the search on the second sheet. There's a good step by step for rotation on the following link.

| improve this answer | |
  • Please see our help center on the guidelines of a link-only answer. – Ramhound Sep 9 '17 at 23:39
  • The answer initially did not have a link since rotating the table 180° is the solution suggested. Since not everyone knows how to rotate, I included the link for reference. my point of view, the link was not the answer. Then again, I'm new to the community. – Fernando Eblagon Sep 10 '17 at 7:48
  • @FernandoEblagon You're right, this is not a link-only answer. Ramhound was a bit too eager, I think :P – Clonkex Jul 9 '18 at 1:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.