Concept: Find Data in Sheets
Search or Filter Entire Sheets
On standard and cube sheets, you can use the
Find
toolbar button or filters to find any match on the sheet in row headers or cells. During the search, we don't include:
- Column headers.
- Unselected drop-down options.
On modeled sheets, you can use the
Display Options
filter or toolbar filter to refine which data to display.Search Modeled and Standard Sheet Drop-Down Lists
On modeled and standard sheets, you can search any:
- Toolbar drop-down menu.
- Cell drop-down menu.
Search Versions
On any sheet type, you can search for specific versions on the versions drop-down menu.
Search Cube Sheet Dimensions
On cube sheets, you can configure dimensions as either:
- Columns.
- Dimension filters.
- Rows.
- TheFindtoolbar button for dimensions in rows.
- The search in the dimension filters.