When I sort a list, How can I keep blank rows between the fields?

E

Erin

We have a list from our school district that needs to have spaces inbetween
the typed in fields. When we add new people to the list and try to sort it,
we can not get it to keep the spaces inbetween the names...help!
 
K

Kooster

Keep the master list in Excel and perform the sorts. Then mail merge the data
into a Word doc that is set for the proper spacing. Use the Word doc for
reporting and distribution.

P.
 
S

SMB BGWA

Sort rows (which remove blanks), insert a column that you can enter an index
number and number every row. Number the same number of blank rows beneath
your list starting from 1 again. Sort rows by these index numbers and it
should give you first row "1" with your data on it, second row "1" which is
blank....
 
M

Mikeopolo

You could also try keeping the rows together but setting the row height
to twice the usual, hence giving the appearance of double spacing ;)

Regards
Mike
 
R

RagDyeR

In XL ... hidden rows *DON'T SORT*!

So, hide the blank rows:

Click in the datalist and hit
<F5>
Click "Special"
Click "Blanks"
Click <OK>

Your blank rows are all selected.
Now, from the toolbar
<Format> <Row> <Hide>

Select your datalist and perform your normal sort.

After the sort, while the list is *still* selected, reverse the hide:
<Format> <Row> <UnHide>

And you should be back where you started, with your data sorted and blank
rows between them.

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

We have a list from our school district that needs to have spaces inbetween
the typed in fields. When we add new people to the list and try to sort it,
we can not get it to keep the spaces inbetween the names...help!
 
Top