How to insert text table in excel spreadsheet

D

Dach

I need a section at the bottom of my spreadsheet where I can type text that
will auto enter to the next line when you get to the edge just like in a text
document. Wrap text in a cell does not work because the column with stays the
same as the setting for that column above this text area, and you end up with
a really long row. I know in Word you can insert a worksheet, but can you
reverse that and insert a word box in a spreadsheet?
 
G

Gary''s Student

First:
View > Toolbars > Drawing

Then click on the text box icon and draw your textbox. Then enter text in
it. You can then re-shape the box in the usual fashion at the grab points.
 
A

Art

I generally use Gary's TextBox solution. However when I want more
funtionality with regard to formatting the text, I've pasted a word document
into a spreadsheet. There's more overhead with Word so I typically use a
TextBox instead -- but depending on what you want there's that other option.
 
Top