Voci con l'etichetta :
Chiudi
Changelog
Chiudi
Voci con l'etichetta :
Chiudi
Provalo nel cloud

Add cell background and borders

Add cell background

To apply and format cell background,

  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. to apply a solid color fill to the cell background, click the Background color Background color icon icon situated at the Home tab of the top toolbar and choose the necessary color.
  3. to use other fill types, such as a gradient fill or pattern, click the Cell settings Cell settings icon icon at 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 theme colors, or standard colors on the palette, or specify a custom color.

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

      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 situated at the Home tab of the top toolbar or click the Cell settings Cell settings icon icon at 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 submenu or use the Color palette at the right sidebar and select the color you need 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.
Alla pagina precedente
Try now for free Try and make your decision No need to install anything
to see all the features in action