Skip to main content

Toolbar Buttons Reference

Home Tab​

ButtonAction
SaveSave all pending changes to Frappe
RefreshReload data from Frappe (discards unsaved changes)
Add RowAppend a new blank row
Delete RowDelete selected row(s)
BoldToggle bold on selected cells
ItalicToggle italic on selected cells
UnderlineToggle underline
Align LeftLeft-align text
Align CenterCenter-align text
Align RightRight-align text
Background ColorOpen color picker for cell fill
Text ColorOpen color picker for font color
Number FormatOpen number format dropdown
BordersOpen border style dropdown
Clear FormatRemove all formatting from selected cells

View Tab​

ButtonAction
Focus CellToggle crosshair highlight on active row/column
Focus ColorColor picker for crosshair color
Hide RowsHide selected rows
Show All RowsUnhide all hidden rows
Formula PrecedentsToggle green outline on formula source cells
Freeze ColumnsSet number of frozen (pinned) left columns
Meta ColumnToggle _meta (modified time) column
Activity ColumnToggle _social (like/comment/assign) column

Data Tab​

ButtonAction
Choose ColumnsOpen field picker modal
Smart LookupOpen Smart Lookup sidebar
FilterOpen filter builder dialog
SortOpen sort dialog
RefreshReload data (same as Home → Refresh)
ImportOpen import dialog
ExportExport submenu (XLSX / CSV)

Insert Tab​

ButtonAction
Insert ChartOpen chart builder
Insert PivotOpen pivot builder for current sheet
New SheetAdd sheet (blank / DocType / report / query)
SparklineInsert sparkline in selected cell

Format Tab​

ButtonAction
Conditional FormattingOpen CF rules dialog
BordersOpen border editor
Number FormatOpen number format dialog
Clear FormatRemove all formatting from selected cells