I'm trying to autofill data in Excel while controlling which values change. Here's a dummy version of what I'm trying to do:
Excel.PNG
I want the values for the C to be the sum of the value in A1 and each of the values in the B column. In other words, I want it to shift values for column B but not C. Of course I could fill all the values in Column A with 5, but for the cases I'm working on, those cells would have other values. Is there a way to do this? Thanks!
Bookmarks