Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close

Add cell background and borders

Add a cell background

To apply and format a cell background,

  1. select a cell or a cell range with the mouse or the whole worksheet by pressing the Ctrl+A key combination,

    Note: you can also select multiple non-adjacent cells or cell ranges holding down the Ctrl key while selecting cells/ranges with the mouse.

  2. to apply a solid color fill to the cell background, click the Background color Background color icon icon on the Home tab of the top toolbar and choose the required color.
  3. to use other fill types, such as a gradient fill or pattern, click the Cell settings Cell settings icon icon on the right sidebar and use the Fill section:
    • Color Fill - select this option to specify the solid color you want to fill the selected cells with.

      Color Fill

      Click the colored box below and select one of the following palettes:

      Palette

      • Theme Colors - the colors that correspond to the selected color scheme of the spreadsheet.
      • Standard Colors - a set of default colors. The selected color scheme does not affect them.
      • Custom Color - click this caption if the required color is missing among the available palettes. Select the required colors 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 selected element and added to the Custom color palette.

    • Gradient Fill - fill the selected cells with two colors which smoothly change from one to the other.

      Gradient Fill

      • Angle - manually specify an exact value in degrees that defines the gradient direction (colors change in a straight line at the specified angle).
      • Direction - choose a predefined template from the menu. The following directions are available: top-left to bottom-right (45°), top to bottom (90°), top-right to bottom-left (135°), right to left (180°), bottom-right to top-left (225°), bottom to top (270°), bottom-left to top-right (315°), left to right ().
      • Gradient - click on the left slider Slider under the gradient bar to activate the color box which corresponds to the first color. Click on the color box on the right to choose the first color in the palette. Drag the slider to set the gradient stop i.e. the point where one color changes into another. Use the right slider under the gradient bar to specify the second color and set the gradient stop.
    • Pattern - select this option to fill the selected cells with a two-colored design composed of regularly repeated elements.

      Pattern Fill

      • Pattern - select one of the predefined designs from the menu.
      • Foreground color - click this color box to change the color of the pattern elements.
      • Background color - click this color box to change the color of the pattern background.
    • No Fill - select this option if you don't want to use any fill.

Add cell borders

To add and format borders to a worksheet,

  1. select a cell, a range of cells with the mouse or the whole worksheet by pressing the Ctrl+A key combination,

    Note: you can also select multiple non-adjacent cells or cell ranges holding down the Ctrl key while selecting cells/ranges with the mouse.

  2. click the Borders Borders icon icon on the Home tab of the top toolbar or click the Cell settings Cell settings icon icon on the right sidebar and use the Borders Style section,

    Cell settings tab

  3. select the border style you wish to apply:
    1. open the Border Style Border Style icon submenu and select one of the available options,
    2. open the Border Color Border Color icon icon submenu or use the Color palette on the right sidebar and select the required color from the palette,
    3. select one of the available border templates: Outside Borders Outside Borders icon, All Borders All Borders icon, Top Borders Top Borders icon, Bottom Borders Bottom Borders icon, Left Borders Left Borders icon, Right Borders Right Borders icon, No Borders No Borders icon, Inside Borders Inside Borders icon, Inside Vertical Borders Inside Vertical Borders icon, Inside Horizontal Borders Inside Horisontal Borders icon, Diagonal Up Border Diagonal Up Border icon, Diagonal Down Border Diagonal Down Border 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