Enter the same text into multiple Excel cells at once


Same text into multiple excell cellsIn Microsoft Excel, you can enter the same data or text into multiple cells at once using the below simple steps.

  1. Highlight all the cells that you want to have the same text.
  2. Type the text you want.
  3. When done instead of pressing enter press Ctrl+Enter.

After completing the above steps, the text will automatically be entered into all highlighted cells. This tip can be very useful any time you have data that has the same prefix and just need to add something to the end of each cell.

For example, the above steps were been done to create “computer hope” in all the cells as shown in the picture to the right. Once completed, I could press F2 on a selected cell, go to the end, and add “1” to make the cell “computer hope 1”. I could keep doing this to have computer hope 1 through 16.

 

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s