MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Use The Same # In Various Cells In Numbers

If you have anumber in cell a1 and want to use it in a formula in column b how can you lock it in so that you don’t have to retype it each time?
—–
JEREMY POWERS

Comments: 6 Responses to “How Do I Use The Same # In Various Cells In Numbers”

    6 years ago

    So you want B1 to be the exact same number as A1? Just use the simplest formula. In B1, put the formula as just A1. So click on cell B1, type the = key to enter formula entry mode, then type A1 and hit Return. Now B1 will mirror the value in A1.

    Jeremy Powers
    6 years ago

    We are trying to drag all of a formula in col B and use cell A1 locked into all cells in col B formula.

    6 years ago

    Jeremy: Sorry, I didn't follow your last comment. Can you explain in more detail, maybe with real numbers and formulas as examples?

    Jeremy Powers
    6 years ago

    lets say that cell A1 is the number 5 and cells B1 thru B10 are 1, 2, 3, etc. cells C1 is "=A1*B1" and cell C2 is "= A1*B2" and cell C3 is "= A1*B3". How can I keep A1 constant without retyping it in each cell?

    6 years ago

    Jeremy: Ah, what you are talking about is absolute cell references. I have a video that explains that: Relative and Absolute Cell References In Numbers.

    Jeremy Powers
    6 years ago

    We figure the problem out. It had to do with a drop down in the formula which allows one to freeze a cell. You do a great job.

    Thanks

Comments Closed.