![]() ![]() A mixed reference, such as B$1, will lock the row to row 1, while allowing the column to change. A mixed reference, such as $B1, will lock the formula to column B, while allowing the row to change. To create a multiplication table, you need to use a mixed reference. ![]() In a previous lesson, you learned how to use an absolute reference in Excel, such as $C$1, so that Excel would not change from column C or row 1 as it copied the formula. The Method - Using a Formula with Mixed Cell References So, feel free to experiment and make your table with any dimensions you like. The beauty of using the method described in the next section to create the multiplication table is that it takes basically the same amount of time to make a quick table that gives results for multiplying any two numbers between 1 and 12 as it does to make much larger tables. 176 (click any image for a larger view), you want to enter a single formula in cell B2 that can be copied to the entire table. ![]() ![]() Problem: Create a multiplication table to help your kids in school. Making a Multiplication Table with a Single Formula ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |