#Easy numbering xcel how to

You can use similar steps to add, subtract or even divide in Excel. Hit ‘Enter’ and you’re done! The result is available at once. So, what we’ve just done is that we’ve told Excel to multiply the number in cell A2 with the number in cell B2. Next, we need to add the symbol for the mathematical operation we want to carry out, so we’ll use an asterisk, which is used for multiplication in Excel.Īfter that, click on the cell which contains the multiplier, which is B2. Once we’ve selected the cell, we can see how another part of the formula appeared after the ‘equal’ sign – it’s the cell reference, A2. Then we click on the cell that contains the first number to be multiplied, in this case, it’s cell A2. This works as some kind of signal to Excel that we want to enter a formula in the cell. Let’s select cell C2 for our first calculation. Thanks to an easy formula, we’ll multiply them and the result will appear in column C.įirst, click on the cell in which you want to display the result.

There are numbers written in columns A and B.

#Easy numbering xcel how to

We’ll use this table as an example to show how to work out anything we need, step by step.

Here we’re gonna concentrate on the basic, simple way how to multiply two numbers in a table. To start with, it’s important to realise that there’s more than one way how to do multiplication in Excel, and these methods are more advanced. 2 How to Copy Formula into Adjacent Cells by Using the Fill Handle Basic Way How to Multiply Numbers in Excel