Enter the Same Text Into Multiple Excel Cells at Once.

Enter the Same Text Into Multiple Excel Cells at Once.


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

  • Highlight all the cells that you want to have the same text.

  • Type the text you want.

  • After typing the text, instead of pressing Enter, press Ctrl+Enter.

  • After completing the above steps, the text will automatically be 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.

    What is an Operating System? » Computer Shortcut Keys and their Functions » Keyboard Function Keys » Computer Basics - Hardware - Software - Parts

    Short Stories for Kids - Moral Stories – English Short Stories for Children - Moral Stories for Kids - Stories for Kids - Funny Story for Kids - Scary Stories for Kids - Really Funny Short Stories - Bedtime Stories
    Proverb Stories
    Powerful
    Motivational Quotes for Students
    » Success Quotes » English Short Stories for Kids

    Cabin Crew Jobs & Career Advice » Secretary Job Description » Receptionist Job Description » Top 100 Interview Questions and Answers » How to Prepare for an Interview » How to Write a CV » How to Choose a Career » Computer Shortcut Keys and their Functions

    Scholarships in Australia » Scholarships in Austria » Scholarships in Belgium » Scholarships in Canada » Scholarships in Germany » Scholarships in Ireland » Scholarships in Italy » Scholarships in Japan » Scholarships in Korea » Scholarships in Netherlands » Scholarships in Switzerland » Scholarships in UK » Scholarships in USA

    Scholarships for Study in Africa » Scholarships for African Students » Undergraduate Scholarships » African Women Scholarships & Grants Scholarships for Study in Africa » Scholarships for African Students » Undergraduate Scholarships » African Women Scholarships & Grants Scholarships for Study in Africa » Scholarships for African Students » Undergraduate Scholarships » African Women Scholarships & Grants

    Scholarships for Study in Africa » Scholarships for African Students » Undergraduate Scholarships » African Women Scholarships & Grants Scholarships for Study in Africa » Scholarships for African Students » Undergraduate Scholarships » African Women Scholarships & Grants Scholarships for Study in Africa » Scholarships for African Students » Undergraduate Scholarships » African Women Scholarships & Grants

  • Click here to post comments

    Join in and write your own page! It's easy to do. How? Simply click here to return to Computer Basics FAQ.