Format data in Datasheet view
You can format the contents of a column that supports multiple lines of text if the column supports rich HTML text. You can format part of a cell, or one or more cells or columns of this data type.
Note To enable support for rich HTML text for a column, in the Change Column page, select Yes under Allow rich HTML text.
- Select the text or the cells that you want to format.
- If the task pane is not open, click Task Pane on the toolbar.
- Apply the format you want. You can change font settings, text and background color, and indentation and alignment. You can also organize text into a list of numbered or bulleted items.
Notes
- You can clear rich HTML text formatting by selecting text, then pressing CTRL+Space. However, CTRL+Space does not remove the alignment setting.
- You cannot format read-only cells or the Total row.
- Formatting does not apply to rows hidden as a result of a filter.