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 ...
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.
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.
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 )