Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel formula help needed... copying multiple cells?
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!
2 Answers
- 5 years ago
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.
