Drag the formula down to the other cells in the column by clicking and dragging the little “+” icon at the bottom-right of the cell.To apply the formula, we need to follow these steps: Table structure for the multiplication table Creating the Multiplication tableįirst, we will create the formula in the cell C3 and then copy it to the rest of the cells. The results of the multiplication will be in the range C3:L12.įigure 2. Our table consists of numbers 1-10 in both first row and column. Setting up Our Data for Creating a Multiplication Table By setting the formula like this, we can easily copy the formula to the whole range and cells references will be changed accordingly. In the first parameter, we must fix the column and in the second the row. Multiplication table formula Syntax of the Multiplication Table FormulaĪs we will copy the formula through the matrix of the cell, the fixing of the cells is very important. ![]() ![]() This step by step tutorial will assist all levels of Excel users in creating a multiplication table.įigure 1. Excel allows us to create a Multiplication table formula, using the simple multiplication and correct cell fixing.
0 Comments
Leave a Reply. |