ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to insert text table in excel spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/138255-how-insert-text-table-excel-spreadsheet.html)

Dach

How to insert text table in excel spreadsheet
 
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?

Gary''s Student

How to insert text table in excel spreadsheet
 
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.
--
Gary''s Student - gsnu200714


"Dach" wrote:

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?


Art

How to insert text table in excel spreadsheet
 
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.

"Dach" wrote:

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?



All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com