I am not proficient in spreadsheets so maybe this is easy. I need a formula for a column to add from a previous column. Specifically, F5 should equal F4 + E5. I can get this done once but I want to extend the formula down the entire F column. How do I do this? Thanks!
[Re-Titled by Moderator]
Original Title: Maybe an easy one?
iPhone 12 Pro Max, iOS 18
Click on the cell with the formula in it. Hover over the lower line of the selection box and a yellow circle will appear. Drag down on it. The formula will adjust its cell references for all those cells you dragged it into.
Another way is the select the cell with the formula. Copy. Select the cells that need the formula. Paste.
Click on the cell with the formula in it. Hover over the lower line of the selection box and a yellow circle will appear. Drag down on it. The formula will adjust its cell references for all those cells you dragged it into.
Another way is the select the cell with the formula. Copy. Select the cells that need the formula. Paste.
In iOS you click on the cell then choose "Cell actions" then "Autofill Cells" then you can drag down/sideways.
I didn't get a yellow circle but the 2nd suggestion worked great. Thank you!
Formula for adding values from previous column in a spreadsheet in Numbers
