Can I Double-Space a completed Doc?
Posted by Katy on June 21, 2001 1:52 PM
Oh- this should be easy with all I know about excel....a colleague asked me if he could double-space a worksheet after it is completed. The only way I know (or can figure out) is to do it line by line. Any pointers?
Posted by Mark W. on June 21, 2001 2:01 PM
May I recommend a more efficient alternative? Why
not double the row height and format cells so
that their content vertically aligned at the
top of the cell.
Posted by mseyf on June 21, 2001 2:20 PM
Changing row height it probably the most efficient, but another thought is to insert a column, insert a series of numbers down the column equal to the number of rows of data (ie if there are 10 rows of data, insert 1 though 10 in the new column). Then copy the series of numbers again in the same column, starting in the next call after the last number, then sort the entire range based on the new column. Might be fun to play with.
-Mark
