Excel2007 enter the same content and formula in multiple cells

Many times we need to enter the same values in multiple cells in Excel, and these cells may be a number of nonadjacent positions, if a manual input that is a waste of time, there is no better way to have wood to enter the same content in these cells? This chapter explains in detail how to enter the same content and formula techniques in multiple cells in Excel!

The example below, this operation version is Excel2007, this method adapts to each version.

① First, select the cells that you want to enter the same content. Press Ctrl + left mouse button to select multiple cells;

② and then in the last selected cell, enter the content, such as here I enter the Word federation, enter the finished immediately followed by the Excel shortcut "Ctrl + enter" can be.