Posted by Brogan on Monday, September 27, 2010 at 12:41pm.
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.

Software  Excel  DrBob222, Monday, September 27, 2010 at 12:47pm
I would type the formula into an empty cell, then copy it to all of the cells below.

Software  Excel  Writeacher, Monday, September 27, 2010 at 12:51pm
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.
Answer This Question
Related Questions
 Desktoping  In a bibliography, each source should be formatted using a ____ ...
 math  when using a calculator to find the square root of a number, which of the...
 Keyboarding and Wording processing?  18. To start keying a new page of a ...
 keyboarding  1. When typing personal titles in correspondence, you should ...
 Computer Math  Can anyone help me? Here's what I'm looking for: Col. A = Base ...
 BCIS  You need to use the help section in your Excel program (press the F1 key ...
 Ed. T  The (fill in the blank) key is used to create spaces between lines ...
 computer  What combination of keys creates the following formatting characters ...
 business ,media  I have a coursework,and i was asked to write,the KEY FACTORS ...
 Statistics  Excel  Can anyone help me with finding Standard Deviation in Excel...
More Related Questions