Change the color of the table in Excel

In this lesson we will learn how to change the color of a table in Excel. For this, we will initialize the original table from the previous lesson by formatting the background and cell borders.

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

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

Now again in the same list, select the option «Thick outer border». Next, select the range A1:D1. In the same section of the tools, click on «Fill color» and point to «Dark Blue». Next, in the «Text color» tool, point «White».



The example of changing the color of tables

The pictures show the process of changing the boundaries in practice:

You can also change the color of a table in Excel using the more functional tool.



Select again the entire table A1:D4. Press the hotkey combination CTRL + 1 or CTRL + SHIFT + F. The multifunction dialog box «Format Cells» will appear.

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

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

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

The helpful advice! Format the data in the last place: so you will save your working time.

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