How to create a field grid in excel

#How to create a Tian grid in excel?

1. First start excel2010, create a new workbook, and execute the view-page layout command.

2. Select the entire table, right-click to select row height, set the row height to 1cm in the row height dialog box, and click OK.

#3. Drag to select a series of columns, also right-click, select column width, set the column width to 1cm, and click OK.

#4. Then adjust the borders around the four squares, select the four squares and execute the ctrl 1 key combination to bring up the border.

#5. Set the color to red, the line style to thicker, select the outer border, and click OK to see the effect.

6. Hold down the ctrl key and select the two diagonal squares in sequence. Repeat steps 4 and 5 to set the diagonal border and upper and lower borders. The line shape is a dotted line. View result.

#7. Select the first four columns, execute the Start-Format Paint command, then drag and brush backwards, and brush downwards in the same way.

The above is the detailed content of How to create a field grid in excel. For more information, please follow other related articles on the PHP Chinese website!