Last Updated on
Last Updated on
Microsoft Excel comes in handy for anything that requires record-keeping and organizing. Inventory, wages, order processing, you name it, Excel is designed to cater to it. However, people sometimes forget about the basic functions in Excel which have the greatest effect.
Excel can do anything from providing a simple spreadsheet to keep figures organized to collating massive company data and displaying that in various forms of cells and charts. This is thanks to the array of formulas Excel supports to make life easier for its users. It’s like anything else, once a user knows what to do, it’s easy.
Calculations are a bit part of Excel’s functionality, and it offers services such as subtracting, dividing multiplication, and more. Rather than quickly working out every calculation needed in a spreadsheet, simply follow the steps below to learn how to multiply single and multiple cells all at once in Microsoft Excel:
First, click the cell that needs the multiplication result. Then, locate the cells that need to be multiplied which should be written in the column then row order. In the example below, we’ve chosen cells B2 and C2.
To activate a formula, start it off with =. This tells Exel that the following text is a formula for it to follow. The character for multiplication in Excel is *, so by inserting =B2*C2 into the necessary cell we will get the multiplication result as shown below.
A quick heads up, users can also use – for subtraction, + for addition, and/or divide. Users can do multiple sums in one cell, but make sure to incase the original sum in brackets to get the correct result. For example, if we needed to include £3 postage onto each model batch pictured, we would write =(B2*C2)+3. Want to work out postage for each separate model? Insert a new column and replace 3 with the correct cells.
Simple, as shown in the example below, click and hold the bottom right corner of the cell when your cursor turns into a cross and drag it over the rest of the columns needing a multiplication formula. Don’t worry about inputting the correct cells, Excel will figure this out and do it automatically. This also applies to addition, subtraction, and division.