{"id":34090,"date":"2025-04-21T20:45:45","date_gmt":"2025-04-22T01:45:45","guid":{"rendered":"https:\/\/excelevate.co\/wp\/?page_id=34090"},"modified":"2025-11-03T21:59:12","modified_gmt":"2025-11-04T03:59:12","slug":"xlev8-manual-global-search","status":"publish","type":"page","link":"https:\/\/excelevate.co\/wp\/home\/support\/xlev8-manual-global-search\/","title":{"rendered":"XLEV8 MANUAL: GLOBAL SEARCH"},"content":{"rendered":"<body><p><\/p>[et_pb_section fb_built=\u201d1\u2033 _builder_version=\u201d4.18.0\u2033 _module_preset=\u201ddefault\u201d custom_padding=\u201d0px|||||\u201d global_colors_info=\u201d{}\u201d][et_pb_row _builder_version=\u201d4.16\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d][et_pb_column type=\u201d4_4\u2033 _builder_version=\u201d4.16\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d][et_pb_text _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d min_height=\u201d28.8px\u201d global_colors_info=\u201d{}\u201d]\n<h1 style=\"text-align: center;\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/excelevate.co\/wp\/wp-content\/uploads\/2020\/10\/read_icon_green_transparent.png?w=30&#038;ssl=1\"  style=\"vertical-align: middle;\" loading=\"lazy\"> <span style=\"vertical-align: middle;\">XLEV8 EXCEL PRODUCT MANUAL<\/span><\/h1>\n<p>\u00a0<\/p>\n<h2 style=\"text-align: center;\">GLOBAL SEARCH<\/h2>\n<p>[\/et_pb_text][et_pb_toggle title=\u201dDetails\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n<p><span style=\"font-size: medium;\"><strong>What it does<\/strong><\/span><br>Shows an auto-complete search form that can find macros, LAMBDA functions, files, sheets, and named ranges to help you quickly run commands, and navigate your workbooks.<\/p>\n<p><span style=\"font-size: medium;\"><strong>When to use it<\/strong><\/span><br>When you want to search for commands to run that you don\u2019t have a keyboard shortcut defined for.<\/p>\n<p><span style=\"font-size: medium;\"><strong>Why to use it<\/strong><\/span><br>This brings together several auto-complete search boxes in one, while still being able to manage the searched items just like those separate search boxes (example: set\/unset keyboard shortcuts for macros or favorite them).\u00a0 This effectively makes it one super-powerful shortcut to all kinds of common commands.<\/p>\n<p><span style=\"font-size: medium;\"><strong>Default shortcut<\/strong><\/span><br><span style=\"color: #ed3bed;\"><strong>Ctrl+Shift+W<\/strong><\/span><\/p>\n<p><span style=\"font-size: medium;\"><strong>Other Details<\/strong><\/span><\/p>\n<ul>\n<li>Category: Productivity \/ Other<\/li>\n<li>Difficulty: 2\/5<\/li>\n<li>Usage\/frequency: 5\/5<\/li>\n<li>Automation factor: 4\/5 (estimated 30 seconds saved each time used)<\/li>\n<li>Type: Shortcut<\/li>\n<li>Date added: 4\/21\/2025<\/li>\n<li>Tags: search, auto complete, shortcut, macros, LAMBDA, files, sheets, named ranges<\/li>\n<\/ul>\n<p>[\/et_pb_toggle][et_pb_toggle title=\u201dRelated Macros and Articles\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n<p><strong>Related Macros<\/strong><br><a href=\"https:\/\/excelevate.co\/wp\/home\/support\/xlev8-manual-search-macros\/\">Search Macros<\/a><br><a href=\"https:\/\/excelevate.co\/wp\/home\/support\/xlev8-manual-search-lambda-formulas\/\">Search LAMBDA Formulas<\/a><br><a href=\"https:\/\/excelevate.co\/wp\/home\/support\/xlev8-manual-search-recent-files\/\">Search Recent Files<\/a><br><a href=\"https:\/\/excelevate.co\/wp\/home\/support\/xlev8-manual-sheet-action-picker\/\">Sheet Action Picker<\/a><br><a href=\"https:\/\/excelevate.co\/wp\/home\/support\/xlev8-manual-search-named-ranges\/\">Search Named Ranges<\/a><\/p>\n<p><strong>Other Articles<\/strong><br>None<\/p>\n<p>[\/et_pb_toggle][et_pb_toggle title=\u201dExample Files\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n<p>None<\/p>\n<p>[\/et_pb_toggle][et_pb_toggle title=\u201dInstructions\u201d _builder_version=\u201d4.27.4\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<strong>Prerequisites<\/strong><br>\nNone<\/p>\n<p><strong>Instructions<br>\n<\/strong><\/p>\n<p>Run the <strong>Global Search<\/strong> macro.\u00a0 It will prompt you with a search form offering you suggestions as you type.\u00a0 Use the up and down arrows (or click with the mouse) to select a suggested item and insert the entire name in the search box.\u00a0 When the entire name is in the search box, press the Enter key to perform the related action (run a macro, add a Lambda function, open a file, or jump to a sheet\/named range).\u00a0 When the entire name is in the search box, details of the item and related actions are displayed based on what type it is (i.e. for a macro, the keyboard shortcut (if any), category, description, and other details are displayed).<\/p>\n<p>The search results contain an abbreviation so you can tell the different items apart:<\/p>\n<ul>\n<li><strong>ma<\/strong> \u2013 macros<\/li>\n<li><strong>la<\/strong> \u2013 LAMBDA functions<\/li>\n<li><strong>fi<\/strong> \u2013 files<\/li>\n<li><strong>sh<\/strong> \u2013 sheets within the active workbook<\/li>\n<li><strong>na<\/strong> \u2013 named ranges within the active workbook<\/li>\n<\/ul>\n<p>Press the Escape key to clear the search box.\u00a0 If the search box is empty when you press the Escape key, the search box will close.\u00a0 You can also clear the search box by pressing the X icon to the right of the search box.\u00a0 Item-specific details are described below.<\/p>\n<p><strong>Macros<\/strong><\/p>\n<p>The actions you can take that mirror the <a href=\"https:\/\/excelevate.co\/wp\/home\/support\/xlev8-manual-search-macros\/\">Search Macros box<\/a>\u00a0are:<\/p>\n<ul>\n<li>Run a macro<\/li>\n<li>Include active workbook macros (toggle on\/off)<\/li>\n<li>Save\/filter your favorite macros<\/li>\n<li>Set\/unset keyboard shortcuts<\/li>\n<li>Set UI shortcuts<\/li>\n<\/ul>\n<p><strong>LAMBDA Functions<\/strong><\/p>\n<p>The actions you can take that mirror the <a href=\"https:\/\/excelevate.co\/wp\/home\/support\/xlev8-manual-search-lambda-formulas\/\">Search Lambda Formulas box<\/a>\u00a0are:<\/p>\n<ul>\n<li>Add a LAMBDA function (or a group of them) from your library to your active workbook<\/li>\n<li>Toggle the auto-save Lambda to library setting<\/li>\n<li>Remove one or more Lambda functions from your library<\/li>\n<li>Manage your Lambda library in bulk<\/li>\n<\/ul>\n<p><strong>Recent Files<\/strong><\/p>\n<p>The actions you can take that mirror the <a href=\"https:\/\/excelevate.co\/wp\/home\/support\/xlev8-manual-search-recent-files\/\">Search Recent Files<\/a> box are:<\/p>\n<ul>\n<li>Open a file last saved from within your specified time range<\/li>\n<li>Save\/filter your favorite files<\/li>\n<li>Remove one or more files from the file history.<\/li>\n<\/ul>\n<p><strong>Sheets<\/strong><\/p>\n<p>Searching sheets mirrors the Search Sheets macro (also an option in the <a href=\"https:\/\/excelevate.co\/wp\/home\/support\/xlev8-manual-sheet-action-picker\/\">Sheet Action Picker<\/a>) \u2013 giving you the ability to jump to any sheet in the active file (including hidden or deeply hidden sheets).\u00a0 The visibility status and tab color of all sheets is displayed when you navigate through the search results.<\/p>\n<p><strong> Named Ranges<\/strong><\/p>\n<p>Searching named ranges mirrors the <a href=\"https:\/\/excelevate.co\/wp\/home\/support\/xlev8-manual-search-named-ranges\/\">Search Named Ranges<\/a> box \u2013 giving you the ability to jump to any named range in the active file.\u00a0 The underlying reference is displayed when you navigate through the search results.[\/et_pb_toggle][et_pb_toggle title=\u201dScreenshots\u201d _builder_version=\u201d4.27.4\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n<div style=\"text-align: center;\">\n<div style=\"text-align: center;\">\n<div id=\"attachment_27292\" style=\"width: 887px\" class=\"wp-caption aligncenter\"><img data-recalc-dims=\"1\" decoding=\"async\" aria-describedby=\"caption-attachment-27292\" src=\"https:\/\/i0.wp.com\/excelevate.co\/wp\/wp-content\/uploads\/2025\/04\/Global-Search_Screenshot_2025-04-21.png?resize=877%2C534&#038;ssl=1\" width=\"877\" height=\"534\" alt=\"\" class=\"wp-image-27292 size-full\" style=\"display: block; margin-left: auto; margin-right: auto; text-align: center;\" loading=\"lazy\"><p id=\"caption-attachment-27292\" class=\"wp-caption-text\">Screenshot of Global Search macro.<\/p><\/div>\n<\/div>\n<\/div>\n<p>[\/et_pb_toggle][et_pb_toggle title=\u201dVideo\u201d _builder_version=\u201d4.27.4\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<iframe loading=\"lazy\" title=\"XLEV8 How-to: Global Search\" width=\"1080\" height=\"608\" src=\"https:\/\/www.youtube.com\/embed\/MWOYl29C5Zw?feature=oembed\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>[\/et_pb_toggle][et_pb_comments _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d][\/et_pb_comments][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<\/body><span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>XLEV8 Add-in how to: Global Search &#8211; Use auto-complete searching find macros, LAMBDA functions, files, sheets, and named ranges very quickly in one place!<\/p>\n","protected":false},"author":1,"featured_media":34091,"parent":299,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-34090","page","type-page","status-publish","has-post-thumbnail","hentry"],"aioseo_notices":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/34090","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/comments?post=34090"}],"version-history":[{"count":5,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/34090\/revisions"}],"predecessor-version":[{"id":34919,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/34090\/revisions\/34919"}],"up":[{"embeddable":true,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/299"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/media\/34091"}],"wp:attachment":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/media?parent=34090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}