![]() |
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? |
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? |
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