{"id":25078,"date":"2022-08-06T17:08:34","date_gmt":"2022-08-06T16:08:34","guid":{"rendered":"https:\/\/ekiwi-blog.de\/?p=25078"},"modified":"2022-08-06T17:10:47","modified_gmt":"2022-08-06T16:10:47","slug":"excel-find-search-from-bottom-to-top-backwards-search","status":"publish","type":"post","link":"https:\/\/ekiwi-blog.de\/en\/25078\/excel-find-search-from-bottom-to-top-backwards-search\/","title":{"rendered":"Excel search from bottom to top (backwards search)"},"content":{"rendered":"

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.<\/p>\n

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<\/em>” or “Find next<\/em>“.<\/p>\n

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

\"Screenshot
sample Excel spreadsheet<\/a> to be searched from bottom to top<\/figcaption><\/figure>\n

Approach<\/h2>\n
    \n
  1. Press “Ctrl+F” to call up search dialog or start menus<\/a> \u27a4 “Find & Select”. \u27a4 Click “Find…<\/em>“<\/li>\n
  2. Enter your search term<\/li>\n
  3. Hold down the Shift key<\/strong> and click on “Find next<\/strong><\/em>“<\/li>\n<\/ol>\n
    \"Screenshot
    Press Shift key and click “Continue search” finds first search hit from below<\/figcaption><\/figure>\n

    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.<\/p>\n\n

    \n\n \n \n
    \n\n Bestseller No. 1<\/span>\n
    \n \n \"Microsoft\n <\/a>\n\n <\/div>\n\n
    \n \n Microsoft Excel 365 Bible <\/a>\n
    \n <\/div>\n <\/div>\n\n
    \n\n
    \n \n 47,10 EUR<\/span>\n \n \"Amazon<\/a> <\/div>\n\n Buy on Amazon<\/a>\n <\/div>\n\n<\/div>\n\n \n \n
    \n\n Bestseller No. 2<\/span>\n
    \n \n \"EXCEL:\n <\/a>\n\n <\/div>\n\n
    \n \n EXCEL: The Complete Guide \u2013 Master Formulas... <\/a>\n
    \n <\/div>\n <\/div>\n\n
    \n\n
    \n \n 16,60 EUR<\/span>\n \n \"Amazon<\/a> <\/div>\n\n Buy on Amazon<\/a>\n <\/div>\n\n<\/div>\n\n \n<\/div>\n","protected":false},"excerpt":{"rendered":"

    Excel permeates our everyday office life and is often used to manage data and long lists. These lists and tables<\/p>\n","protected":false},"author":2,"featured_media":12366,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1555],"tags":[1702,1703,2168,1565,1558],"class_list":["post-25078","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software-en","tag-excel-en","tag-microsoft-en","tag-office-en","tag-software-en","tag-windows-en"],"_links":{"self":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts\/25078","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/comments?post=25078"}],"version-history":[{"count":0,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts\/25078\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/media\/12366"}],"wp:attachment":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/media?parent=25078"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/categories?post=25078"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/tags?post=25078"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}