Results 1 to 3 of 3

Thread: How to insert a paragraph break inside a Cell of Microsoft Excel

  1. #1
    Join Date
    Jan 2012
    Posts
    20

    How to insert a paragraph break inside a Cell of Microsoft Excel

    I am trying to enter text in an excel spreadsheet. The text has multiple paragraphs. I would like to have all text from one section in one cell and dont want to enter new paragraphs in multiple cells. Are there any manual commands that I can enter to perform this action.

  2. #2
    Join Date
    Sep 2010
    Posts
    71

    Re: How to insert a paragraph break inside a Cell of Microsoft Excel

    Press Alt+Enter to insert a new line within a single cell. It is not really effective to put a page break inside a cell in Microsoft Excel. It might not look appropriate, but you can give it a try.

  3. #3
    Join Date
    Aug 2010
    Posts
    27

    Re: How to insert a paragraph break inside a Cell of Microsoft Excel

    Just don't try to get too much text into a cell. You can enter up to 32,767 characters in a cell but only 1024 will be visible or printed. Add an ALT + ENTER every 100 chars to increase the 1024 limit.

Similar Threads

  1. Replies: 2
    Last Post: 17-02-2012, 07:09 PM
  2. Replies: 2
    Last Post: 17-02-2012, 06:52 PM
  3. Replies: 2
    Last Post: 17-02-2012, 01:09 PM
  4. How to replace all paragraph marks in Microsoft Excel
    By Tritanic in forum MS Office Support
    Replies: 2
    Last Post: 09-02-2012, 06:36 PM
  5. Way to insert a Date Picker in MS Excel cell
    By Chulbul Pandey in forum Windows Software
    Replies: 3
    Last Post: 10-12-2010, 11:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •