Set font type, size, style, and colors

You can select the font type and its size, apply one of the decoration styles and change the font and background colors using the corresponding icons situated at the Home tab of the top toolbar.

Note: in case you want to apply the formatting to the data already present in the spreadsheet, select them with the mouse or using the keyboard and apply the 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		Is used to select one of the fonts from the list of the available ones. If a required font is not available in the list, you can download and install it on your operating system, after that the font will be available for use in the desktop version.
Font size		Is used to select among 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 to the font size field and then press Enter.
Increment font size		Is used to change the font size making it larger one point each time the icon is clicked.
Decrement font size		Is used to change the font size making it smaller one point each time the icon is clicked.
Bold		Is used to make the font bold giving it more weight.
Italic		Is used to make the font italicized giving it some right side tilt.
Underline		Is used to make the text underlined with the line going under the letters.
Strikeout		Is used to make the text struck out with the line going through the letters.
Subscript/Superscript		Allows to choose 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		Is used to change the color of the letters/characters in cells.
Background color		Is used to change the color of the cell background. Using this icon you can apply a solid color fill. The cell background color can also be changed using the Fill section at the Cell settings tab of the right sidebar.
Change color scheme		Is used to change the default color palette for worksheet elements (font, background, chats and chart elements) selecting one of the available ones: Office, Grayscale, Apex, Aspect, Civic, Concourse, Equity, Flow, Foundry, Median, Metro, Module, Odulent, Oriel, Origin, Paper, Solstice, Technic, Trek, Urban, or Verve.

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 at the Home tab of the top toolbar:

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 at the top toolbar,
3. select any color in the available palettes

   

   • Theme Colors - the colors that correspond to the selected color scheme of the spreadsheet.
   • Standard Colors - the default colors set.
   • Custom Color - click this caption if there is no needed color in the available palettes. Select the necessary colors range moving the vertical color slider and set the 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 specify a color on the base of the RGB color model entering the necessary 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 specified, click the Add button:

     

     The custom color will be applied to the selected text/cell and added to the Custom color palette.

To clear the background color of a certain cell,

1. select a cell, or a range of cells with the mouse or the whole worksheet using the Ctrl+A key combination,
2. click the Background color
   icon at the Home tab of the top toolbar,
3. select the
   icon.

Alla pagina precedente