Is it possible to get Excel to search "backwards," i.e. to the left and up?

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?

3

2 Answers

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.

1

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.

3

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

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