Find a specific value in a table or input table (Beta)

🚩
This documentation describes one or more public beta features that are in development. Beta features are subject to quick, iterative changes; therefore the current user experience in the Sigma service can differ from the information provided in this page.
This page should not be considered official published documentation until Sigma removes this notice and the beta flag on the corresponding feature(s) in the Sigma service. For the full beta feature disclaimer, see Beta features.

The Find in table feature allows you to locate specific values in a table or input table. It searches across all visible (not hidden) columns in the element and highlights each match so you can quickly navigate between results using Next and Previous controls.

This document explains how to search across table and input table cells.

Requirements

The ability to search across table and input table cells requires access to a workbook containing a table or input table element.

Limitations

The Find in table feature can search table and input table elements only. It is not supported by pivot tables or charts.
Results are only returned for rows currently loaded in the browser memory (initially up to 10,000 rows). If the table or input table contains more than 10,000 rows, you can scroll to the bottom of the table to load additional rows. You can also apply filters to exclude irrelevant rows and load others.

Find a value in a table or input table

Use the Find in table feature to search for a specific value in a table or input table.

Open a workbook, data model, or report containing a table or input table element.
Locate the table or input table element you want to search.
Use one of the following methods to access the search functionality:
- Element menu: In the element toolbar, click More and select Find in table.
- Keyboard shortcut: Select the element, then press ctrl + f (Windows) or ⌘ + f (Mac).
In the search bar, enter the value you want to find. Search results are case-insensitive and support partial matches.
Sigma highlights each cell containing a match. Use the Next and Previous buttons to navigate between results.
To close the search bar, click Close.