F
Firecracker
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?
introduction to the figures that will then follow in columns?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
PriorityDone
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.
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.
M
Mike Rogers
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
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
J
JLatham
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.
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.