Font, fill and borders
The font, fill and border commands apply cell formatting to the selected range.
- Select the cells to format.
- Use the Bold, Italic and Underline buttons, or Ctrl+B, Ctrl+I, Ctrl+U.
- Choose a typeface and size from the Font Family and Size combos, or grow and shrink them.
- Apply a font colour or fill colour from the swatch grid menus, including Automatic and No Fill.
- Apply a border preset such as All Borders, Outside or a thick box from the Borders gallery.
Tip The buttons and combos reflect the active cell's current formatting whenever you change the selection. To format whole rows or columns, select them by clicking their headings, or the whole sheet with Ctrl+A: the formatting also applies to the empty cells, including those beyond the last value, and whatever you type there later comes out already formatted.