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

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.

Dan wrote:
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 FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Does this aply to newer versions of excel?

"Debra Dalgleish" wrote:

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.

Dan wrote:
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 FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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 (InsertObject), and
use its formatting features.

Dan wrote:
Does this aply to newer versions of excel?

"Debra Dalgleish" wrote:


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.

Dan wrote:

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 FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

"Debra Dalgleish" wrote:

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 (InsertObject), and
use its formatting features.

Dan wrote:
Does this aply to newer versions of excel?

"Debra Dalgleish" wrote:


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.

Dan wrote:

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 FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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.

On Mon, 21 Mar 2005 07:09:02 -0800, Dan wrote:

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

"Debra Dalgleish" wrote:

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 (InsertObject), and
use its formatting features.

Dan wrote:
Does this aply to newer versions of excel?

"Debra Dalgleish" wrote:


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.

Dan wrote:

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 FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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 InsertObject
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

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

"Debra Dalgleish" wrote:


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 (InsertObject), and
use its formatting features.

Dan wrote:

Does this aply to newer versions of excel?

"Debra Dalgleish" wrote:



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.

Dan wrote:


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 FAQ, Tips & Book List
http://www.contextures.com/tiptech.html




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html