Cell borders

By default, when you create a document, there are no borders between cells. The grid visible on the sheet conventionally separates cells one from another to make working with data easier, and is not displayed when printing.

To add borders to cells or change settings previously applied to borders, follow these steps:

1.Select the desired cell or range of cells.

2.On the Home tab, in the Font group, click the arrow to the right of the  Cell borders button.

3.In the border settings pane that opens, in the first settings block, specify the position of the borders for which you want to change the parameters.

4.In the second block of settings, select the type of line to be applied to the specified borders.

5.In the third block of settings, specify the line color using one of the following methods:

•Choose a color from one of the color sets provided.

•Specify the color code manually.

•Copy the color using the eyedropper.

Choose a color from the color sets provided

In the border settings pane, you will find the following sets of colors in the third settings block:

–Theme colors: This block contains the color palette of the current document's theme.

–Standard colors: This block contains the colors that users most often choose when formatting a document.

–Recent colors: This block contains up to the last ten colors that you selected when formatting the document earlier. The Recent colors set is displayed if you have selected at least one color.

Hovering the mouse cursor over any color displays the value of that color in the RGB color model. For example, RGB 192,80,77.

Left-click a color to select it.

To close the border parameters pane, do one of the following:

–On the Home tab, in the Font group, click the arrow to the right of the  Cell borders button.

–Click a blank area of the document outside the border settings pane.

Specify the color code manually

If you do not find a suitable color in the listed sets of the settings pane, you can specify its code manually:

1.Click More colors.

2.In the Select color window that appears, specify the desired color as a HEX code or in RGB format.

3.Click OK.

Copy the color with an eyedropper

You can use the eyedropper to simultaneously copy a color from a text or object located in the main window's workspace and apply that color to cell borders.

To copy a color using the eyedropper, follow these steps:

1.Click  Eyedropper on the border settings pane. The pane will close and the cursor will look like a crosshair for color selection.

2.Hover the cursor over the color in which you want to color the cell borders. For more accurate color selection, refer to the area to the right of the cursor. It displays the color of the pixel that the cursor is currently hovering over.

3.Left-click the color.

If you want to disable the eyedropper without selecting a color, press Esc.

Apply the last selected border style

To quickly apply the last selected border style to a cell or range of cells, follow these steps:

1.Select the desired cell or range of cells.

2.On the Home tab, in the Font group, click  All borders.

Remove borders

To remove specified cell or cell range borders, follow the steps below:

1.Select the desired cell or range of cells.

2.On the Home tab, in the Font group, click the arrow to the right of the  Cell borders button.

3.In the border settings pane that opens:

•In the first block of settings, specify where you want the borders to be deleted.

•In the second block of settings, select No borders.

4.To close the border parameters pane, do one of the following:

•On the Home tab, in the Font group, click the arrow to the right of the  Cell borders button.

•Click a blank area of the sheet outside the border settings pane.