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 would type the formula into an empty cell, then copy it to all of the cells below.
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.
To "FILL DOWN (CTRL D)" in Excel, follow these steps:
1. Type your formula in the first cell of the column where you want it to be applied.
2. Press Enter to calculate the value of the formula for that cell.
3. Move your cursor to the cell with the formula you just entered.
4. Press and hold the Ctrl key on your keyboard.
5. Press the letter D while still holding the Ctrl key. This will autofill the formula down the column, copying the formula to all the cells below.
6. Release both the Ctrl key and the letter D.
After completing these steps, the formula should be copied and applied to all the cells below, adjusting the cell references accordingly.
Alternatively, you can use the Fill Handle to achieve the same result by following these steps:
1. Type your formula in the first cell of the column.
2. Press Enter to calculate the value for that cell.
3. Move your cursor to the bottom right corner of the cell until the cursor changes to a thin, black crosshair symbol.
4. Click and hold the left mouse button.
5. Drag the fill handle down to the last cell where you want the formula to be applied.
6. Release the mouse button.
The formula will be automatically filled down to the selected cells in the column.
Remember to review and double-check the results to ensure the formula has been filled correctly.