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
MacMost Q&A Forum • View All Forum Questions • Ask a Question
How Do I Use The Same # In Various Cells In Numbers
Comments: 6 Responses to “How Do I Use The Same # In Various Cells In Numbers”
Comments Closed.
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.
We are trying to drag all of a formula in col B and use cell A1 locked into all cells in col B formula.
Jeremy: Sorry, I didn't follow your last comment. Can you explain in more detail, maybe with real numbers and formulas as examples?
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?
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.
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