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

How Do I Do This Simple Task?

When I am trying to create an equation where a row of numbers is multiplied or added to a specific cell.

ie (f13*G12) and then try to drag to autofill the remaining numbers what happens is (F14*G13, F15*G14…..)

Where I want F14*G12, F15*G12….

I want to have as little data as possible on the screen and want to be able to fix a specific cell into that function while I autofill a row.

—–
Patrick

Comments: One Response to “How Do I Do This Simple Task?”

    5 months ago

    What you want to do is to set one of the values to absolute, while you leave the other as relative.

    When you enter the original formula, say F13*G12, click on G12. It then presents you with two checkboxes: Preserve Row, Preserve Column. Set one or both of those so when the formula is copy and pasted, or autofilled, then that reference will not change.

    So in your example, you don’t want G12 to change to G13, G14, and so on. So set Preserve Row. Now when you autofill the 12 in G12 will remain the same. So you get F14*G12, F15*G12 and so on.

    See https://macmost.com/relative-and-absolute-cell-references-in-numbers.html

Leave a New Comment Related to "How Do I Do This Simple Task?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)