Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
is there a way to automaticly fill in a multiplication table? In Cells A2 to
A13 I have 1, 2, 3...11,12. I then have 1 in B1, 2 in C1, 3 in D1, etc. Or in other words, numbers 1-12 going down column A (starting at A2) and numbers 1-12 going across row 1 (starting at B1). Is there a way to fill this entire thing in with one formula and dargging? I know "=A$2*B1" will work for the entire row, but not the whole table. Thanks guys, Robbi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Multiplication Table | Setting up and Configuration of Excel | |||
table | Excel Discussion (Misc queries) | |||
table | Excel Worksheet Functions | |||
Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions |