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 cell or cell range where you want to change the borders.

2.On the Toolbar, in the Cells section, click the arrow to the right of the  button.

3.In the window that opens, in the first block of settings, specify the position of the borders you need to change the parameters of.

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, select a line color from one of the following groups:

•Theme Colors: This section contains the color palette of the current document's theme.

•Standard Colors: This section 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.

6.If there is no matching color in the sections listed above, you can define it manually. To do this, click More Colors button. In the Select Color window that appears, specify the desired color as a HEX code or in RGB format and click OK.

7.To close the border parameters window, do one of the following:

•On the Toolbar, in the Cells section, click the arrow to the right of the  button.

•Click a blank area of the sheet outside the window.

Border settings window

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 Toolbar, in the Cells section, click .

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

1.Select the desired cell or range of cells.

2.On the Toolbar, in the Cells section, click the arrow to the right of the  button.

3.In the window that opens, configure the required parameters:

•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 window, do one of the following:

•On the Toolbar, in the Cells section, click the arrow to the right of the  button.

•Click a blank area of the sheet outside the window.