how to change border color in excel

Modify the color of the table in Excel

In this lesson we volition learn how to alter the color of a table in Excel. For this, we volition initialize the original tabular array from the previous lesson by formatting the background and jail cell borders.

Immediately go over to do. We select the whole table A1:D4.

On the «Domicile» tab, click on the «Borders» tool, which is located in the «Font» section. From the drib-down listing, select the option «All borders».

At present again in the same list, select the option «Thick outer border». Next, select the range A1:D1. In the aforementioned department of the tools, click on «Fill up color» and bespeak to «Dark Bluish». Next, in the «Text color» tool, bespeak «White».

The example of changing the color of tables

The pictures prove the process of changing the boundaries in do:

changing the boundaries.

You tin can as well change the color of a tabular array in Excel using the more functional tool.

Select again the unabridged table A1:D4. Press the hotkey combination CTRL + ane or CTRL + SHIFT + F. The multifunction dialog box «Format Cells» volition announced.

Format Cells.

Commencement become to the «Edge» tab. In the «Presets» toolbar of this tab, click the «Inside» button. Now in the line blazon section, select the thickest line (second from the bottom in the right cavalcade). If necessary, set the color for the borders of the table below. Then go back to the «All» department and click on the «Outline» button. To confirm the border formatting settings, click OK.

Presets.

Also we can make a colors text. Select the headings of the original table A1:D1. Open the «Format Cells» window. At nowadays go to the «Font» tab and in the text color field select «Yellowish». To change the color of the selected cell in Excel, click the «Fill» tab and click on «Blackness». To ostend the change of the format of the cells, click OK. Pasting cells in Excel allows you lot to select a row or column by color.

As you tin can run into in the «Format Cells» window there are multiplicity of tools, that expand the possibilities of formatting data.

The helpful advice! Format the information in the last identify: so you lot will save your working fourth dimension.

The formatting opens up wide possibilities for data exposure. There are the irresolute fonts and sizes of text, setting background colors and patterns, paint border colors and select the type of their lines, etc. But if y'all slightly overdo with the colour change a petty, the Excel sheet becomes colorful and unreadable.