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. Doing this will apply column formatting to both existing and newly added cells in the column. Doing this will apply row formatting to both existing and newly added cells in the row. Take this action before you click a formatting icon Follow the guidance below to help with this. You can format groups of data all at once. You can learn more on this in our Auto-Fill Formatting and Formulas article. 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.Column headers are always formatted in white, bold text with a grey background.To change these setting, use the instructions in the Change the Language and Date Notation article. The thousands and decimal separators for numbers are controlled by the Language (Country) settings in your Regional Preferences.For a list of keyboard shortcuts, see the Keyboard Shortcuts article. TIP: Many of the tasks you do with formatting buttons can also be done with keyboard shortcuts. If you don't see a button that you need, click More. To apply formatting to numbers and text in your sheet, use the buttons on the toolbar at the top of the Smartsheet window.įor certain views or screen sizes, not all buttons will be visible on the toolbar.
