Excel formula help needed... copying multiple cells?

Question

I can't remember what the command is in Excel to do the following:  If you write a formula with variables, and then you grab the little 'dot' in the lower right corner and pull it down, it modifies the formula by changing the cells automatically.  So if my formula is =A5 + B7, the cells below it will look like this:
=A6 + B8
=A7 + B9
=A8 + B10
=A9 + B11
and so on....

But what if I want the A column to ascend (like the example above), but I want the other variable to stay the same (so B7 stays B7 for all copies)... how do I do that?  I remember once adding something to the B7 (maybe an exclamation mark?), but I can't find it now.

Thanks!

kokhwatan · Accepted Answer

=A5 + $B$7

lura · Answer

If I understand you correctly, you can select all the worksheets while holding the ctrl button (or right click and "select all sheets") and any changes made on one worksheet in a cell will be in effect on all selected sheets. That will work if all the cells on the various worksheets are in the same location.

Excel formula help needed... copying multiple cells?

Related Questions

Trending Questions