Forum Discussion
Excel formulas in a column
Is there a "universal" formula can I use that will work in each cell in the balance column with this document? I'm pretty new to this, so don't know how to do this other than to keep entering the for...
Thanks very much for all the info. I will check out those resources. But for today, I really need to get this fixed, and realize it must be frustrating to help someone new to this. I don't see a demo file, and nothing I clicked on appeared to be that...is it a video? If I copy the formula in the first cell, do you mean I then paste that same formula in every cell in the column, and it will automatically change the formula for each, or is there a way to apply that universally to all in one fell swoop?
You don't see this at the bottom of my reply? That "basicAdding.xlsx" is an Excel file. Click on the black down pointing arrow to download it. But all it contains is the formula and a few dummy pieces of data. The main point is that I just did a mass copy....paste.
You wrote: If I copy the formula in the first cell, do you mean I then paste that same formula in every cell in the column, and it will automatically change the formula for each, or is there a way to apply that universally to all in one fell swoop?
Yes. It will adjust itself for every cell going down. You do a mass copy/paste, one time.
- Thank you for all your input!