Numbers spreadsheet on iPad pro
How do I copy a formula down a column, in Numbers spreadsheet on an iPad Pro?
iPad Pro, iOS 13
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
How do I copy a formula down a column, in Numbers spreadsheet on an iPad Pro?
iPad Pro, iOS 13
Hello BeatricePotter,
Welcome to the Apple Support Communities. I understand you want to copy the formula throughout a column.
With Numbers on your iPad you can select cells, rows, and columns as shown in this article: Select tables, cells, rows, and columns in Numbers on iPad.
You can also follow these steps to copy and paste formulas: Copy and paste formulas in Numbers on iPad.
Thanks and have a great day.
I read the links provided nicholas and think there is one more thing that is missing that i dont see in the online help guide. It looks like they are only talking about copying and pasting one cell at a time. I think your question is how to fill it down to fill the column.
Once you enter in the first formula,
select that cell and are ready to copy it down,
you then tap the "Cell" button on the bottom right hand side of the screen.
now Tap the larger "Autofill cells" button on the menu that pops up.
this will change the border around your selected cell to a yellow one with little lines showing where you can tap/hold and drag the box down. this will fill your formula down the column.
Sadly there is no autofill whole column mode, you have to physically drag it down the whole thing.
Jason
Thank you, very helpful.
Numbers spreadsheet on iPad pro