How Excel changes a table to a dashed line

Users in order to change the Excel table style to make the cell into a dashed lattice, do not know where to start setting, the following to teach you to create a dotted line of the method!

Tutorial steps:

Open the Excel table box select the cell that you want to make a dashed line.

Figure 1

Then click "format" → "Cell".

Figure 2

The cell format selection border is now displayed.

Figure 3

Then set the dotted line, first click on the "line" in the "dotted line" as shown in Figure ①, and then click "Color" to select the color "blue" or other colors such as Figure ②, and then click "Inside" as the figure ③, and finally filled the dotted line as figure ④.

Figure 4

After the setup is complete, the following figure shows.

Figure 5