June 21, 2021

SEO, Wordpress Support & Insurance, Mortgage, Loans, Legal, Etc Blogs

SEO, Wordpress Support & Insurance, Mortgage, Loans, Legal, Etc Blogs

, SEO, Wordpress Support & Insurance, Mortgage, Loans, Legal, Etc Blogs

Enter the same text into multiple Excel cells at once

Share This :
, SEO, Wordpress Support & Insurance, Mortgage, Loans, Legal, Etc Blogs

Updated: 11/16/2019 by Computer Hope

, SEO, Wordpress Support & Insurance, Mortgage, Loans, Legal, Etc Blogs

In 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. After typing the text, instead of pressing Enter, press Ctrl+Enter.

After completing the above steps, the text automatically is entered into all highlighted cells. This tip is useful if you have data with the same prefix and need to add something to the end of each cell.

For example, the above steps were done to enter “computer hope” in all the highlighted cells, as shown in the picture. 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 for each cell to have computer hope 1 through 16.

Additional information

  • See our cell and Excel definitions for further information and related links on these terms.
Share This :