Apply formatting to data

To apply formatting to numbers and text in your sheet, use the buttons on the toolbar at the top of the Smartsheet window.

For certain views or screen sizes, not all buttons will be visible on the toolbar. If you don't see a button that you need, clickMore.

You can complete formatting tasks with keyboard shortcuts. For a list of keyboard shortcuts, see theKeyboard Shortcutsarticle.

NOTES:

• Thethousandsanddecimal separatorsfor numbers are controlled by the Language (Country) settings in your Regional Preferences. To change these setting, see把语言和日期表示法s.
• Column headersare always formatted in white, bold text with a grey background. You cannot change this style.
• Formatting will be automatically applied to a cell if it's directly above, below, or between two cells that contain the same formatting and are on the same indent level. Learn more inAuto-Fill Formatting and Formulas.

Conditional formatting

You can set rules to change the format of a cell when the data in that cell changes, for example, highlight a row in red when a deadline is past due and a task is not marked as complete.

SelectConditional Formattingand follow the instructions on your screen.

Learn more aboutconditional formatting.

Format groups of data

You can format groups of data all at once. Follow the guidance below to help with this.

To apply formatting to	Take this action before you click a formatting icon
An entire row	Select the row number to apply row formatting to existing and newly added cells in the row.
An entire column	Select the column header to apply column formatting to existing and newly added cells in the column.
An entire sheet	Highlight all columns in the sheet by clicking the left-most column's header, scrolling to the right, then Shift+clicking the right-most column's header. When you release your click, all columns and rows in the sheet should be highlighted and you can then set formatting for the entire sheet.

Apply date formatting

You can apply different date formats (for example, long form dates) with the steps inApply a Standardized Date Format in Your Sheet.

Indent and outdent

Indent rows to create an organized structure to your sheet, with child rows that fall under a parent row. You can use these hierarchical relationships along with formulas, for example, to automatically calculate a weighted percent complete on a parent task based on data in the child tasks. Details about how to do this on this are included in theParent Rolluparticle.

For more information on creating hierarchical relationships, check out the article onusing hierarchy.

Font and cell formatting

Draw attention to certain elements of your sheet by setting various font and cell background formats. For example, you can set bold font for parent rows to make them stand out more.

在选择的区域表,你可以ge font type and size, background color, as well as alignment and text wrapping in cells. You can not apply borders to cells or rows.

Wrap text

Select the cell in which you want to wrap text and clickWrap Text.

Clear formatting

UseClear Formats
to return your selection back to the default font and cell background. This is useful for quickly removing formatting from a section of your sheet without removing the data in the cells.

Format painter

To quickly copy an existing format on your sheet to other cells, use the Format Painter tool:

1. Select the cells that contain your desired format.
2. Click格式的油漆er.
3. To instantly copy that formatting to a new destination, select the desired new cell.
   TIP: Double-click the格式的油漆erbuttonto lock the format. You can then continuously apply the locked format to cells. Click the格式的油漆erbutton again, or press Esc to release the locked format.

Highlight changes

EnableHighlight Changesto gain visibility on recent edits made to your sheet. Details on this are available in theHighlight Changesarticle.

Numeric formatting

Buttons for formatting numbers are grouped together.

If you don't see these buttons on the toolbar, you may need to clickMore.

ClickCurrency Formatto automatically format numeric values with the appropriate currency symbol and decimal position.

UsePercentage Formatto treat numbers as percentage of 1. If you format a cell this way, the value 0.95, for example, will be is displayed as 95%. The value 95 will be displayed as 9,500%.

You can enableThousands Formatto include the thousands separator and decimal.

ClickIncrease DecimalorDecrease Decimalto move the decimal point.

NOTES:

• Smartsheet treats numbers combined with other characters (letters, punctuation) as text. You can’t use the Numbers tools with text values.
• The symbols used fordecimalandthousands separatorsfor currency and number format are controlled by the Regional Preferences specified for your account. For more information, see the把语言和日期表示法article.