double line spacing using excel 2000

[Guest]

I have a paragraph of writing, how do i get the text to be double line
spaced? I am using excel 2000.

 

[Debra Dalgleish]

Excel doesn't have a line spacing setting. You could add line breaks by
pressing Alt+Enter at the end of a line, then another Alt+Enter to
create a blank line.

 

[Guest]

Does this aply to newer versions of excel?

Excel doesn't have a line spacing setting. You could add line breaks by
pressing Alt+Enter at the end of a line, then another Alt+Enter to
create a blank line.

 

[Debra Dalgleish]

Yes, in newer versions of Excel you'd have to add manual line breaks to
simulate double spacing.

In any version, you could insert a Word Document (Insert>Object), and
use its formatting features.

 

[Guest]

i double spaced the paragraph in word then imported it into excel. The
paragraph went back to single spaced!!

 

[Myrna Larson]

In Word, you have settings for line spacing, which apply to the space that is
added between lines when the document is viewed or printed. Excel, being a
spreadsheet program and not a word processor, doesn't have this setting. I
believe the closest you'll come is to set the alignment for the cell to Wrap
Text, and the vertical alignment to Justify. Then you can increase the row
height and get the appearance of "double spacing" within the cell. But if you
have some cells in the row that need, say, 5 lines, with others that need only
2, the latter cells will have much more space between lines than the former.

 

[Debra Dalgleish]

How did you import it?

In Word, create and save a document with the formatting you want
(a maximum of 1 page will display in Excel)
In Excel, you could choose Insert>Object
Select the 'Create from file' tab
Click the Browse button
Find and select the Word document that you created.
Click the Insert button
Click OK

 

[Guest]

Debra D, Thank you for solving my problem

How did you import it?

In Word, create and save a document with the formatting you want
(a maximum of 1 page will display in Excel)
In Excel, you could choose Insert>Object
Select the 'Create from file' tab
Click the Browse button
Find and select the Word document that you created.
Click the Insert button
Click OK

 

[Debra Dalgleish]

You're welcome. Thanks for letting me know that it solved the problem.