Share via

multiplication tables on excel

Anonymous
Feb 12, 2016, 7:33 PM

hello, 

i am trying to make a simple multiplication table on excel. 

I am doing this by first computing 1 *1, my code is

=B$1 * $A2.

 then when i copy the first cell, and past the formula all the way through it gives me a bunch of 1's

but if i click on a particular cell, then click on the formula bar, the formula highlights the corresponding cells  in blue and red, and when i click enter, it then gives me the appropriate value.  

what am i doing wrong???!!!!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question. To protect privacy, user profiles for migrated questions are anonymized.

0 comments No comments
{count} votes
Accepted answer
  1. Bob Jones AKA CyberTaz 425.2K Reputation points
    Feb 13, 2016, 12:41 PM

    Sounds like you have Manual calculation specified...

    • Go to Excel> Preferences - Calculation & select Automatic, or
    • Use the Calculation Options button on the Formulas tab to select Automatic, or
    • Use either the Calculate Now or the Calculate Sheet button on the Formulas tab if you have reason to leave manual calculation selected.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    Feb 14, 2016, 1:43 AM

    it worked!!! 

    thanks so much!!!

    0 comments No comments