|
double line spacing using excel 2000
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 |
Debra D, Thank you for solving my problem
"Debra Dalgleish" wrote: 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 |
You're welcome. Thanks for letting me know that it solved the problem.
Dan wrote: Debra D, Thank you for solving my problem "Debra Dalgleish" wrote: 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 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| All times are GMT +1. The time now is 02:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com