Archive of Mr Excel Message Board

double spacing

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.