Excel search from bottom to top (backwards search)

Excel permeates our everyday office life and is often used to manage data and long lists. These lists and tables are often filled chronologically. The newest entry is often inserted at the bottom last row. If you want to use the search and find function to find a search term that is entered last, you need to search from bottom to top or you have to search the Excel column backwards.

By default, however, Excel searches the columns fromleft to right and top to bottom, so that you first get a lot of old search hits and you have to click through to the last search result with “F3” or “Find next“.

As an example, we will use a list of names in our spreadsheet. We would like to find the name “MacGyver” starting from the bottom, i.e. the first occurrence of the search hit from the bottom or the last entry with this search term.

Screenshot Excel list backwards search starting from the bottom
sample Excel spreadsheet to be searched from bottom to top

Approach

  1. Press “Ctrl+F” to call up search dialog or start menus ➤ “Find & Select”. ➤ Click “Find…
  2. Enter your search term
  3. Hold down the Shift key and click on “Find next
Screenshot search result 1st occurrence from below is found
Press Shift key and click “Continue search” finds first search hit from below

As we can see in the picture, in this case the last Excel row with the entry “MacGyver” was found in the names list of the Excel spreadsheet, because the Excel search function scrolls the columns backwards when the Shift key is held down. That means from from bottom beginning every row from right to left and than down to top.

Bestseller No. 1
Bestseller No. 2

Leave a Reply

Your email address will not be published.