Win7 system excel automatic output multiplication port table graphic tutorial

The most indispensable office software for office workers is excel, which can be used for statistics, summarization, report production, and so on. Sometimes we will enter the multiplication table in the excel form. If it is more troublesome to manually input, how can it be convenient? Take a look at the tutorial below.

The specific method is as follows:

Open excel, enter the vbe programming environment;

insert module;

The cell to be used is A1 To I9, first define the width of the cell so that each multiplication port can be displayed completely;

Cycle statement, variable i from 1 to 9, indicating a total of 9 lines;

The second layer loop, variable j from 1 to i, indicating that the first row has 1 column, the second row has 2 columns, the third row has 3 columns, ……, the ninth row has 9 columns; Br>

The content of each cell is a multiplication: number of lines & times; number of columns = their product;

close vbe, start macro in the table; Br>

Execute macro multiplication method;

Output result--multiplication table, total 9 rows and 9 columns.

The above tutorial content is the win7 system excel automatic output multiplication port table graphic tutorial, as long as the setting, the multiplication table appears, is not much simpler than manual input, of course, the excel table also There are other features, more exciting tutorials, please pay attention to this!