Excel tutorial How to set a dotted table

This section of the Excel tutorial is to show you how to set the dotted table method, you need to set the dotted line form and do not know how to set up a friend come in and learn!

Operation Process:

1, open the Excel table box to select the "cell" to make a dashed line.

2, then click "format" → "Cell".

3, now pops up "cell format" select "Border."

4, immediately set the dotted line, first click on the "line" in the "dotted line", such as 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 ④.

5, after the completion of the set, the dotted border is done, as shown in the following figure.