How to Enter Multiple Lines in a Single Excel Cell?


If you are new here, Subscribe to Full Feeds or by Email and receive free daily updates on Tips, Tricks and Tweaks..


Excel2007

Many times you may have used word wrap to arrange the lines in an Excel cell so that it occupies the correct cell width you prefer. But what if you don’t like the way it wraps the text or you want to forcefully word wrap after a particular word in a sentence in an Excel Cell?

For example, in the picture below, in the first cell the text is word wrapped automatically and in the second cell it is word wrapped after the ‘Lyte Byte –‘ forcefully.

Enter Multiple Lines in Excel cell

So here is the tip, wherever you want to manually insert word wrap or to write in more than one line within Excel cell, use keyboard shortcut Alt + Enter. This will allow to enter multiple lines within a single Excel cell with ease and on the go.


Related Posts:
  • How to use Relative and Absolute References in Excel?
  • Advanced Feature Add-In to Get Live Data from Web in Excel 2007
  • How to Change Text Orientation in Excel Cells?
  • How to do Quick Sum in Excel Using AutoSum and its Keyboard Shortcut?
  • What are A1 and R1C1 Reference Style in Excel?


  • Enjoyed this post? Subscribe to Full Feeds or by Email and receive free daily updates on Tips, Tricks and Tweaks.


    7 Responses to “How to Enter Multiple Lines in a Single Excel Cell?”


    1. 1 Keith Dsouza

      I always enjoy your excel tips, you are the excel guru, I always turn to search your posts when I face some difficulties using excel :)

    2. 2 Mr.Byte

      @Keith Dsouza, Nice to hear that. I write tips as i face some issues and challenges when i work with excel.

    3. 3 Sandip

      Great Tips, Thanks for sharing even after working on Unix/Linux still need Windows Excel for work :P

    4. 4 Khaled

      To be honest, i was looking for something similar, and i have found it :D thank you very much :D

    5. 5 Happy Camper Now

      THANK YOU!, this was very helpful and exactly what I was searching for. Its amazing how easy something is, but how difficult it can be if you dont know the steps to take

      You Rock!

    6. 6 Ash

      Hey Thanks for the Help.

    1. 1 Weekly Links: July 11, 2008 : LostInTechnology

    Leave a Reply




    LyteByte Full Feed

    About Lyte Byte & Me

    Bringing you Tips, Tutorials, and Tweaks on Computers, Internet, Operating System, Windows Vista, Office Applications, Web 2.0, Gadgets, Science, and Technology.
    Its a byte of technology, did you have your byte today?


    subscribe through Email