This will work in any spreadsheet, but I am going to use Google Spreadsheet.

  • Click on the corner of your Google spreadsheet where the rows and columns come together
  • Hold cursor between any two columns (between letters) and resize.  Hold cursor between any two rows (between numbers) and resize.  You want to make square boxes out of the cells.
  • Usually I do not start in the corner, so I put a 1 somewhere in the sheet.
  • Type a 2 next to the cell
  • Highlight the 1 and 2.  Notice a little square appears in the bottom right.  Grab the square and pull it to the right.  This will continue the number pattern horizontally.
  • For the vertical list of numbers you need to place the other 1 kitty corner to the first 1.
  • Place a 2 under the 1 and highlight the two cells.  Again grab the square in the bottom corner. Pull down.
  • This creates the left and top rows of your multiplication table.  The values will be created by using a formula.
  • In the cell where you would have 1 times 1 start with an equals sign.
  • In this example my 1’s are in cells D3 and C4.  Instead of typing 1*1 use cell referencing.  =D3*C4
  • However, before you push enter you want to remember you will ALWAYS be multiplying by that top row (Row 3) and ALWAYS multiplying by the left column (Column C).
    • To lock down Row 3 put a dollar sign in front of the 3.
    • To lock down Column C put a dollar sign in front of the C.
  • After pushing enter the value of 1*1 should appear.
  • Click back on the cell with the formula.  Notice the square in the bottom right of the cell.
  • Grab the square and pull it to the right as long as you have the top row of values.
  • Keep the row highlighted. Grabbing the square in the bottom right pull down to finish filling out the multiplication table.

Subscribe to the Alice Keeler Newsletter


Want to sponsor the newsletter? Click here

WP Twitter Auto Publish Powered By :
%d bloggers like this: