answersLogoWhite

0


Best Answer

Enter one set of numbers in a column and another set of numbers in a row at the top of that column, so that the numbers you want to multiply intersect at a column and row.

EXAMPLE:

In A2 enter 2.

In B1 enter 3.

In B2 enter =A2*B1 (observe the answer 6)

TIP: If you want to be able to enter the formula only in the first intersecting cell of the row, then copy the formula to all the rest of the cells in the row, use the formula =$A$2*B1. That will make A2 and absolute reference that will not change as you copy the formula to other cells in the row, but will automatically update B1 to C1, D1, etc.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do make an times table on Microsoft Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp