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

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!

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

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.
--
Overcome Sales Barriers
http://salesbarriers.typepad.com/


"Erin" wrote:

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!

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

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....

"Erin" wrote:

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!

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

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


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=564985

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

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!
================================================== ===

"Erin" wrote in message
...
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!