Archive of Mr Excel Message Board


Back to Edit in Excel archive index
Back to archive home

double spacing

Posted by Chris Fry on May 28, 2001 5:35 AM
How do I double space a large work sheet that is currently single spaced?

Re: double spacing

Posted by Dave Hawley on May 28, 2001 5:47 AM


Hi Chris

Go to Edit>Replace and place your mouse insertion point in the "Find What" box, making sure it is at the very start. Now push the space bar once. In the "Replace with" box push the space bar twice.


Dave

OzGrid Business Applications


Re: double spacing of lines

Posted by Chris Fry on May 28, 2001 9:04 AM



double line spacing

Posted by Kevin James on May 28, 2001 10:51 AM
Chris,

You are going about it the hard way. Merely increase the size of the row height for all rows to be included in the report.

Kevin


Re: double spacing

Posted by Gil on June 07, 2001 2:58 PM

Not sure if you solved your problem with the double spacing, the responses didn't seem to help as I interpreted your problem.

Solution I would use.

Put a dummy column in to left or right of rows to be double spaced, insert odd number count, 1 3 5 .... down the rows, pull(copy) the count down as many rows as you have. Then add even numbers under the odds in blank rows below the information. Now select all of the information you want to double space and including the dummy rows of odds and evens. Sort the information by the dummy column in ascending order.


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.