View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
AFSSkier AFSSkier is offline
external usenet poster
 
Posts: 94
Default When I sort a list, How can I keep blank rows between the fields?

What is the need for the spaces between the records? Not knowing this I can
only suggest the following.

A: You could keep the spaces by having an extra column with an "X" or
something on each line including the spaced ones. Then sort the "X" field
first.

or
B: Increase (double) the Row Height like you do the column width.
--
Thanks, Kevin


"Erin" wrote:

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