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 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 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.

     

     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.

     

     • 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 (0°).
     • Gradient - click on the left 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 - 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 icon situated at the Home tab of the top toolbar or click the Cell settings icon at the right sidebar and use the Borders Style section,

   

3. select the border style you wish to apply:
   1. open the Border Style submenu and select one of the available options,
   2. open the Border Color 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 , All Borders , Top Borders , Bottom Borders , Left Borders , Right Borders , No Borders , Inside Borders , Inside Vertical Borders , Inside Horizontal Borders , Diagonal Up Border , Diagonal Down Border .

Alla pagina precedente