Automatically fill a formula downward in Excel 2007

Posted on June 28, 2010 by Sam

You can automatically fill a formula downward, for all adjacent cells that it applies to, by double-clicking the fill handle of the first cell that contains the formula. For example, you have numbers in cells A1:A10 and B1:B10, and you type the formula =A1*B1 in cell C1. Selecting cell C1 and double-clicking the fill handle will copy that formula into cells C2:C10.

Share

About Sam

I am an MCAS: Windows Vista, MCTS: Business Desktop Deployment, MCTS: Microsoft Office Project 2007. This blog is all about MCAS. I will be sharing information about MCAS exam. I am here to share information about different Microsoft exams. You all can ask questions from me about any certification exam and you can also share your experiences with me.
Posted in 77-602. Tags: . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>