Fill command in Excel 2007

Posted on October 22, 2009 by Sam

There are many ways to repeat information in many cells in Excel throughout a worksheet. The most convenient way to repeat information in contiguous cells is by using the Fill command.

The Fill command is used to fill the active cell with the content of the adjacent cell. The Fill command is run through Home tab > Editing group > Fill.

FillCommand

Click the Down, Right, Up, Left, or Series option to fill cells. If the first cell contains a formula, the formula will be repeated in the additional cells. If the first cell contains text, the text will be repeated in the additional cells.

Note:To quickly fill a cell with the contents of the cell above or to the left of it, press CTRL+D or CTRL+R.

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>