Results 1 to 2 of 2

Writing paragraphs within Excel

This is a discussion on Writing paragraphs within Excel within the Excel Questions forums, part of the Question Forums category; I have a spreadsheet that I send out to others. I need to have areas within my spreadsheet that allows ...

  1. #1
    New Member
    Join Date
    Sep 2002
    Posts
    34

    Default Writing paragraphs within Excel

    I have a spreadsheet that I send out to others.
    I need to have areas within my spreadsheet that allows for writing paragraphs. Text boxes aren't working for me because I don't know how to limit the characters. Text is getting hidden behind the pre-defined text box I made. I have to stay within certain perameters for printing.
    I've thought of merging cells, but that's really not the solution I'm looking for. I need about 126 cells (A12:I25) to act like a mini Word document.
    Any suggestions????

  2. #2
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,208

    Default

    Hi ROFLO,

    I would suggest you create the "text box" using Word, then copy and paste the Word text into Excel using Paste Special > Word document (and make sure Paste Link option is NOT set). This will embed the Word document into Excel and allow you to edit it by double-clicking on it. You can then use all the Word paragraph formatting capabilities, etc. You can also size it to fit precisely in the cell range of interest by holding down the Alt key as you adjust its size.
    Keep Excelling.

    Damon

    VBAexpert Excel Consulting
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm
    (My other life: http://damonostrander.com )

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com