ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Text in an excel spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/128057-text-excel-spreadsheet.html)

Firecracker

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?

PriorityDone

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?


Mike Rogers

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?


JLatham

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?



All times are GMT +1. The time now is 05:26 AM.

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