change a spreadsheet from single spaced to double spaced?
There is no built in way to do this, the best way in my opinion to do this
without code is this:
insert a column before column a, put a one in the first cell and drag down
so all of your data is now in a numbered row, copy all of those rows (if your
last number is 50 you should be copying only the column that contains it,
1-50) and paste that on the row after your last entry. now sort by this
column, that should give you one space between, then delete the column. paste
2x's for 2 blanks 3x's for 3 etc. Hope that made sense.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.
"tud52" wrote:
i have a very large worksheet and it is single spaced, i would like to make
it double spaced, is there a way to do that other than inserting an empty
row, one at a time?
|