Software - Excel

posted by .

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 -

    I would type the formula into an empty cell, then copy it to all of the cells below.

  • Software - Excel -

    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.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Keyboarding and Wording processing?

    18. To start keying a new page of a document before the current page is filled, you can insert a page break by A. hitting the End key. B. pressing Enter until you insert a soft page break. C. pressing CTRL + Enter. D. changing the …
  2. BCIS

    You need to use the help section in your Excel program (press the F1 key and then use the search feature). If you need additional information about Excel, you can use your textbook or go to http://support.microsoft.com/search/, select …
  3. business ,media

    I have a coursework,and i was asked to write,the KEY FACTORS OF SUCCES,in a industry,which in case it happens to be the television industry.I need to write what we as the customers want from the tv,then we need to find out how the …
  4. Statistics - Excel

    Can anyone help me with finding Standard Deviation in Excel?
  5. window XP

    Windows XP Professional can accommodate the addition and removal of many types of devices. The installation of a device results in the installation of drivers and allocation of resources. Subsequent removal of the device can result …
  6. Desktoping

    In a bibliography, each source should be formatted using a ____ indent. A. center B. hanging C. left D. right I got D. Press ____ in copy selected text to the clipart A. Ctrl + A B. Ctrl + B C. Ctrl + C D. Ctrl + D I got A.
  7. Computer

    The company you work for is having financial problems and has cut your software budget for the coming year. What is a legal viable way to save money on future software purchases?
  8. computer

    What combination of keys creates the following formatting characters in a word document?
  9. keyboarding

    1. When typing personal titles in correspondence, you should always include the person's name if you know it. If you don't know the person's name, which of the following should you use?
  10. Ed. T

    The (fill in the blank) key is used to create spaces between lines within a document. A.Enter b.Tab C.Shift D.Ctrl Is the answer A?

More Similar Questions