Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Create The Multiplication Table In Excel

Date:2021-9-21 Author:Sandra

Why Chinese people are good at math.  That’s because they memorized the multiplication tables in primary school.  Knowing the multiplication table will help you do math more efficiently.  So if you have kids, make sure they learn multiplication tables at an early age. It will definitely make them smarter. Today, we are going to learn how to create the multiplication table in Microsoft Excel.

Let’s prepare the frame of the multiplication table.

How To Create The Multiplication Table In Excel

Highlight the area first and type =IF(B$2>$A3,””,B$2&”*”&$A3&”=”&B$2*$A3) in cell B3. You can just copy and paste this into your cell.

How To Create The Multiplication Table In Excel

Remember to press Ctrl and Enter keys after typing.

How To Create The Multiplication Table In Excel

Now we get the perfect multiplication table!

How To Create The Multiplication Table In Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *