Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text in an excel spreadsheet
How do I type a large piece of text in an excel spreadsheet as an
introduction to the figures that will then follow in columns? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text in an excel spreadsheet
Right click on the cell with the large piece of text, and go to Format Cells.
Then click on the alignment tab and check the Wrap Text option. Click OK. You can then adjust the colun width further if you need to. "Firecracker" wrote: How do I type a large piece of text in an excel spreadsheet as an introduction to the figures that will then follow in columns? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text in an excel spreadsheet
Firecracker
If you need to keep your column widths for your data, just place a text box where you want you intoduction and format it as a nice place setting (lines, no lines; colors if appropriate, etc) Mike Rogers "Firecracker" wrote: How do I type a large piece of text in an excel spreadsheet as an introduction to the figures that will then follow in columns? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text in an excel spreadsheet
Also, since this is just some introductory/explanatory text, this is a time
when it is probably OK to use the Merge Cells feature to combine several cells into one large one to type the text into. This might keep from having to make a single column so wide to accomodate the text that it makes the actual information in the column below it look weirdly or awkwardly formatted. Firecracker - you can use a combination of both suggestions - format the (merged) cell with wrap text to keep it from getting too wide, and you can adjust the height of the row and width of the column to get the appearance you desire, or at least one that's acceptable. "PriorityDone" wrote: Right click on the cell with the large piece of text, and go to Format Cells. Then click on the alignment tab and check the Wrap Text option. Click OK. You can then adjust the colun width further if you need to. "Firecracker" wrote: How do I type a large piece of text in an excel spreadsheet as an introduction to the figures that will then follow in columns? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
Working spreadsheet highlighting function for Excel 2007 | Excel Worksheet Functions | |||
In Excel I want to copy text from spreadsheet to spreadsheet | Excel Worksheet Functions | |||
How do I delete a text box from an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
create excel spreadsheet to display data from filled text forms | Excel Discussion (Misc queries) |