Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close
Try in the cloud
Try in the cloud

Set font type, size, style, and colors

In the Spreadsheet Editor, you can select the font type and its size, apply one of the decoration styles and change the font and background colors by clicking the corresponding icons on the Home tab of the top toolbar.

Note: if you want to apply formatting to the data in the spreadsheet, select them with the mouse or use the keyboard and apply the required formatting. If you need to apply the formatting to multiple non-adjacent cells or cell ranges, hold down the Ctrl key while selecting cells/ranges with the mouse.

Font
Used to select one of the fonts from the list of the available fonts. If the required font is not available in the list, you can download and install it on your operating system, and the font will be available for use in the desktop version.
Font size
Used to select the preset font size values from the dropdown list (the default values are: 8, 9, 10, 11, 12, 14, 16, 18, 20, 22, 24, 26, 28, 36, 48, 72 and 96). It's also possible to manually enter a custom value up to 409 pt in the font size field. Press Enter to confirm.
Increment font size
Used to change the font size making it one point bigger each time the icon is clicked.
Decrement font size
Used to change the font size making it one point smaller each time the icon is clicked.
Change case
Used to change the font case. Sentence case. - the case matches that of a common sentence. lowercase - all letters are small. UPPERCASE - all letters are capital. Capitalize Each Word - each word starts with a capital letter. tOGGLE cASE - reverse the case of the selected text or the word where the mouse cursor is positioned.
Bold
Used to make the font bold making it heavier.
Italic
Used to make the font slightly slanted to the right.
Underline
Used to make the text underlined with a line going below the letters.
Strikethrough
Used to make the text struck out with a line going through the letters.
Subscript/Superscript
Allows choosing the Superscript or Subscript option. The Superscript option is used to make the text smaller and place it to the upper part of the text line, e.g. as in fractions. The Subscript option is used to make the text smaller and place it to the lower part of the text line, e.g. as in chemical formulas.
Font color
Used to change the color of the letters/characters in cells.
Fill color
Used to change the color of the cell fill. Using this icon you can apply a solid color fill. The color of the cell fill can also be changed using the Fill section on the Cell settings tab of the right sidebar.
Change color scheme
This button is located on the Layout tab. Used to change the default color palette for worksheet elements (font, background, chats and chart elements) selecting from the available options: Aspect, Blue Green, Blue II, Blue Warm, Blue, Grayscale, Green Yellow, Green, Marquee, Median, Office 2007-2010, Office 2013-2022, Office, Orange Red, Orange, Paper, Red Orange, Red Violet, Red, Slipstream, Violet II, Violet, Yellow Orange, Yellow, and New Office.

Note: it's also possible to apply one of the formatting presets selecting the cell you wish to format and choosing the desired preset from the list on the Home tab of the top toolbar:

Formatting Presets

To change the font color or use a solid color fill as the cell background,

  1. select characters/cells with the mouse or the whole worksheet using the Ctrl+A key combination,
  2. click the corresponding icon on the top toolbar,
  3. select any color in the available palettes

    Palette

    • Theme Colors - the colors that correspond to the selected color scheme of the spreadsheet.
    • Standard Colors - the default colors set.
    • You can also apply a custom color using two different options:
      • Eyedropper - use this option to choose the required color by clicking it in the spreadsheet.
      • More colors - click this caption if the required color is missing among the available palettes. Select the necessary color range moving the vertical color slider and set a specific color dragging the color picker within the large square color field. Once you select a color with the color picker, the appropriate RGB and sRGB color values will be displayed in the fields on the right. You can also define a color on the base of the RGB color model by entering the corresponding numeric values into the R, G, B (red, green, blue) fields or enter the sRGB hexadecimal code into the field marked with the # sign. The selected color appears in the New preview box. If the object was previously filled with any custom color, this color is displayed in the Current box so you can compare the original and modified colors. When the color is defined, click the Add button:

        Palette - Custom Color

        The custom color will be applied to the text/cell and added to the Recent colors palette.

To remove the background color from a certain cell,

  1. select a cell, or a cell range with the mouse or the whole worksheet using the Ctrl+A key combination,
  2. click the Fill color
    icon on the Home tab of the top toolbar,
  3. select the
    icon.
Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action