Asked by Brogan
Hi, Im doing my maths coursework andI need to type in a formula and press enter and then I need "FILL DOWN (CTRL D)". How do I do this?
I don't want to get the same number from what Ive alreay typed in on the previous cell, I just want that formula to function in the rest of the column.
I don't want to get the same number from what Ive alreay typed in on the previous cell, I just want that formula to function in the rest of the column.
Answers
Answered by
DrBob222
I would type the formula into an empty cell, then copy it to all of the cells below.
Answered by
Writeacher
After you've typed the formula into the cell, press Enter, and then put the cursor back into that cell.
Then when you hold the cursor over that selected cell, the bottom right corner should appear as a plus sign. Click on that + and drag down as far as you want.
You can also highlight all the cells you want that formula repeated in, as long as they're going straight down, and then press Ctrl + D.
Then when you hold the cursor over that selected cell, the bottom right corner should appear as a plus sign. Click on that + and drag down as far as you want.
You can also highlight all the cells you want that formula repeated in, as long as they're going straight down, and then press Ctrl + D.
There are no AI answers yet. The ability to request AI answers is coming soon!
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.