1. First, select the required rows and columns in excel, such as 6 columns and 10 rows, as shown in the following figure:

2. After being selected, right-click and select Set Cell Format, as shown in the following figure:

3. Click the border option, as shown in the figure below:

4. Select the outer border, select the required line style and confirm, as shown in the following figure:

5. Select the first row in the table, as shown in the figure below:

6. Click the merge center above, as shown in the figure below:

7. Enter data in the form, and the form is ready, as shown in the following figure:

Microsoft Excel is a spreadsheet software written by Microsoft for computers using Windows and Apple Macintosh operating systems. Intuitive interface, excellent calculation function and chart tools, coupled with successful marketing, make Excel the most popular personal computer data processing software. 1993, after the release of version 5.0 of Microsoft Office component, Excel began to become the overlord of spreadsheet software on the applicable operating platform.