+ Reply to Thread
Results 1 to 2 of 2

Typing paragraphs in Excel - Help!

  1. #1
    Registered User
    Join Date
    06-02-2014
    Posts
    15

    Typing paragraphs in Excel - Help!

    We are trying to make a form that those that don't know Excel very well can easily use and not have to re-format, etc. to get things to fit on the page.

    I have figured out how to format the cells how I want them to look by merging certain cells then locking the ones we don't want changed while leaving other cells unlocked so the user can tab to the fields they need to fill out (we are using "protect sheet).

    The difficulty comes when they need to type a narrative in a row where I had to merge several cells together. They want to paste their text and then have the merged cell fit the text.

    Or if there's an easier way to insert a field they can tab to and just type what they want - that would be ideal. Currently we are typing what we want in Word and pasting into Excel and then we cannot edit the text, etc. without the user messing up the whole paragraph... and having to stretch the row to fit. Or if we try the Text Box we run into the same thing where the user has to "monkey" with the form.

    There's got to be an easier way - right? I know Excel is known for its formulas, etc. that is why we are creating the form in Excel, however, we need to be able to type paragraphs, also. Any ideas?

  2. #2
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Typing paragraphs in Excel - Help!

    Have you used Wrap Text by any chance since I don't see you reference it in your post.
    If a cell is wrapped, then text is automatically broken to the next line when it hits the end of a cell, whether you type it in or paste it in.
    Regards,
    Rudi

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Randomize text paragraphs within Excel?
    By merlinator in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-19-2009, 11:32 AM
  2. Replies: 2
    Last Post: 06-09-2006, 05:40 PM
  3. [SOLVED] Moving paragraphs from MS Word to Excel
    By [email protected] in forum Excel General
    Replies: 3
    Last Post: 03-01-2005, 11:08 PM
  4. How to select the first 5 paragraphs in a Word Document from Excel
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-12-2005, 12:06 PM
  5. [SOLVED] Display Word Paragraphs in Excel???
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2005, 04:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1