The toolbar on sheets changes based on the sheet type.
|Expands or collapses the formula bar.||All sheets|
|Provides correct formula syntax.||All sheets|
|Submits your changes to the database. Once you save a sheet, other users can see your changes when they open this sheet. Other sheets that use the data are also updated.||All sheets|
Downloads data to a spreadsheet in Microsoft Excel (*xls).
For modeled sheets, the buttons is disabled when the sheet exceeds 1.5 million cells. Use filters to reduce the the number of cells.
|Recalculates formulas on all rows and brings isolated sheets back into sync with the rest of your model.||Modeled and cube sheets|
|Splits the row.||
|Deletes the selected split.||Standard sheets|
|Renames the current split.||Standard sheets|
Adds a new record to a modeled sheet. Reveals a suppressed row or finds a revealed row in a cube sheet. See Add Splits and Rows.
|Modeled and cube sheets|
|Deletes the selected row or rows.||Modeled sheets|
|Changes the copy mode from Copy Formulas Mode to Copy Values Mode . Click the button to toggle between the two modes. See Cut, Copy, and Paste Reference.||All sheets|
|Restores the sheet to the initial view defined by your admin.||Standard and cube sheets|
Filters time ranges, and dimensions.
In modeled sheets:
Let's you create multiple filters per column.
|Conditionally all sheets|
|Choose the dimensions and attributes to display in the rows and columns.||Cube sheets|
|Swaps the row headers with the column headers.||Cube sheets|
|Updates sheet with any new changes which may have been made to the data by other users. Discards any changes you have made prior to saving. Best Practice: Use to erase your unsaved work. To see updates made by others, always save your work first.||All sheets|
|Displays a graphical version of the selected cells. Only available to users with Discovery permissions.||Standard sheets|
|Opens search field so you can enter numbers or words to find matches. Select the up and down arrows to find the next match.||All sheets|
|Opens a keyword field so you can enter numbers or words to show records that match within existing filters.||Modeled sheets|
|Pulls data from a linked modeled sheet.||
Modeled sheets that are linked to other modeled sheets.
|Dropdown menu with all levels you can access. In a standard sheet, the selector has a list of accounts if the rows are levels.||Standard and modeled sheets|
|View or add notes to the sheet. Sheet notes are version and level specific. You can only add notes to a level without sub-levels. If you select a level, you can only see its notes and its sub-level's notes.||All sheets|