Excel enters the same content 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 tutorial will give you a detailed explanation of how you can enter the same content in multiple cells in Excel !

① First, select the cells that you want to enter the same content. PressCtrl + 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.

At this point, all of the cells that you just selected will display the same content. See more Excel Tutorials