HomeApplicationOffice information

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!

4.3 ★ | 3 Vote

You should read it

May be interested

  • How to delete table format in ExcelHow to delete table format in Excel
    how to quickly delete the format on the excel table, to bring the data table back to the normal data area?
  • Apply Picture effects to background colors in PowerPointApply Picture effects to background colors in PowerPoint
    introduce in detail how to apply the picture effect to the background color in powerpoint. step 1: go to the design - format background tab: step 2: the format background window appears, click picture or textture fill - click file.
  • Table in HTMLTable in HTML
    what does it take to create a table in html? is it complicated? want to add color to the table border, how to add the background color to the text in the table? in this article tipsmake.com will answer those questions and guide you to basic operations with tables on html, in addition to adding alternate color schemes for rows in the html table. invite you to follow along.
  • Apply gradient effects to background colors in PowerPointApply gradient effects to background colors in PowerPoint
    introduce how to apply a gradient effect to a background color in powerpoint. step 1: go to the design - format background tab: step 2: the format background window appears, click gradient fill - select the color that appears first in the preset gradient section.
  • How to create borders in PhotoshopHow to create borders in Photoshop
    creating borders, borders for photos to divide the boundaries between the subject and the background image is one of the basic skills in photoshop. in the following article, let's learn about how to create borders in photoshop like okay.
  • Format background color for text page in WordFormat background color for text page in Word
    introduce how to format background colors for text pages in word. 1. coloring the background of a text page. - to color the background of a text page select the design tab - page color - select the color to fill the page: - in case you want to mix multiple colors in your own way
  • Instructions to stamp negative numbers in ExcelInstructions to stamp negative numbers in Excel
    during the spreadsheet process on excel, we will have to work with many types of numbers, including negative numbers. and if you want to differentiate negative numbers from other numbers in the data sheet, you can format close or red brackets to distinguish them.
  • Create borders and fill the background for text in WordCreate borders and fill the background for text in Word
    the first impression of the readers with the book is the cover so the beautiful cover presentation is a very important part when writing documents. this article i will guide you how to create borders and fill the background for text.
  • How to color cells, background colors for tables in WordHow to color cells, background colors for tables in Word
    how to color cells, background colors for tables in word
  • Instructions for creating Dashboard on ExcelInstructions for creating Dashboard on Excel
    excel can be a very powerful program, but sometimes a simple sheet format is not attractive enough for readers to approach it. one of the ways to make your data and tables more attractive is to create a dashboard - an environment that retrieves all the most important information from your document and presents it as a format. ' easy to digest'.

Office information