Writing paragraphs within Excel

ROFLO

New Member
Joined
Sep 3, 2002
Messages
34
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????
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
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.
 
Upvote 0

Forum statistics

Threads
1,213,568
Messages
6,114,348
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top