How do I sort with empty rows between none empty rows?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report I am trying to sort. The problem is I have inserted rows in
between texted rows to kind of make it look better. Now I am trying to sort
and it sorts all the texted rows together, without the inserted empty rows in
between. I took an Excel class and the teacher showed us how to sort
something like this. I don't remeber how to do this. Please help!
 
This might be easier.....

If the only purpose of the blank rows is to provide space between records:
Eliminate the blank rows and make the row heights larger.
That will achieve the same effect and reduce the effort for navigating
within the report.

To eliminate all the blank rows:
Select the first column of the report range
Press the [F5] key....(that's the shortcut for <edit><go to>)
Click the [Special] button and Check: Blanks
Click the [OK] button

While all the blanks are still selected...
<edit><delete><entire rows>

Sort your list
Then..select the list range and change the row heights where appropriate.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sort Excel 2007 to include empty row between data? 2
Hpw do I delete multiple empty rows found between filled rows? 1
parent/child relationship between rows? 3
Relate rows (child/ parent), secure relations for sorting 2
Keeping Rows Together 1
How do I make first row sort in table 2
Sorting 3
ONE ROW WON'T SORT 4

Back
Top