| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I sort a list, How can I keep blank rows between the fields?
Hi This has not been tested, but should work. I would hightlight the column that that I wanted to sort. Once this is done I would use the menu Data -- Filter-- NonBlanks. Once sorted I would use the menu Data --- sort Let me know if this works. Denis -- jetted ------------------------------------------------------------------------ jetted's Profile: http://www.excelforum.com/member.php...o&userid=17532 View this thread: http://www.excelforum.com/showthread...hreadid=564984 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignoring Blank value in a drop down list | Excel Worksheet Functions | |||
| When I sort a list, How can I keep blank rows between the fields? | Excel Discussion (Misc queries) | |||
| Sort with a List | Excel Worksheet Functions | |||
| How do I sort (or group?) a spreadsheet by similar rows? | Excel Worksheet Functions | |||
| Insert rows | Excel Worksheet Functions | |||
Linear Mode
