Format borders and background colors for tables in Excel

The following article details you how to format borders and background colors for tables in Excel.

Format borders and background colors for tables in Excel Picture 1

Step 1: Select the table you want to create borders -> Design -> Quick Styles -> select the table style : Light is the light color format, medium is the medium format type.

Format borders and background colors for tables in Excel Picture 2

Step 2: After choosing the format for the table -> results:

Format borders and background colors for tables in Excel Picture 3

Step 3: If you want to create a new format style, click New Tables Style .

Format borders and background colors for tables in Excel Picture 4

Step 4: The New Table Style dialog box appears, give the name of the format in the Name field, select the elements shown in Table Element, click Format to select other formats for the table:

Format borders and background colors for tables in Excel Picture 5

Step 5: After clicking Format, the Format Cells dialog box appears, select the font formats in the Font section , the border in the Boder section , and create a background color in the Fill section . For example, here select the Boder tab to create a border for the table:

Format borders and background colors for tables in Excel Picture 6

- In case you do not want to use that format for the menu click on Clear:

Format borders and background colors for tables in Excel Picture 7

- After clicking Clear, the result is:

Format borders and background colors for tables in Excel Picture 8

- In addition, you can fill the background color on your own by clicking the table to create background color -> on the Home tab -> select the Fill icon -> select the color to be filled:

Format borders and background colors for tables in Excel Picture 9

- After choosing the color, the result is as shown in the picture:

Format borders and background colors for tables in Excel Picture 10

Above is a detailed guide for formatting borders and background colors for tables in Excel 2013.

Good luck!