| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort data with blank rows dividing data
I need to sort data in a Excel 2003 table while retaining the blank rows in
between the data. Every time I perform a regular sort, the blank rows are returned at the end of the table. I need them to remain between each data row. Is there a way to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort data with blank rows dividing data
Hi Sheila,
use filter to select all blank cell and then put any value in corresponding cell then sort both the row( ALT+d+s) Sanjay "Sheila" wrote: I need to sort data in a Excel 2003 table while retaining the blank rows in between the data. Every time I perform a regular sort, the blank rows are returned at the end of the table. I need them to remain between each data row. Is there a way to do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort data with blank rows dividing data
Sanjay:
I don't understand what you're saying. How do I use the filter to select all blank rows? "Sanjay" wrote: Hi Sheila, use filter to select all blank cell and then put any value in corresponding cell then sort both the row( ALT+d+s) Sanjay "Sheila" wrote: I need to sort data in a Excel 2003 table while retaining the blank rows in between the data. Every time I perform a regular sort, the blank rows are returned at the end of the table. I need them to remain between each data row. Is there a way to do this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort data with blank rows dividing data
Select the first row (click on 1 at left hand side).
From the tool bar select Data|Filter|Auto Filter A drop down arrow should apear on the first cell in each column. Use one of these drop down arrows and select 'non blank' cells. Sort the cells as required. Use the drop down arrow again and filter to 'all'. Job done. "Sheila" wrote: Sanjay: I don't understand what you're saying. How do I use the filter to select all blank rows? "Sanjay" wrote: Hi Sheila, use filter to select all blank cell and then put any value in corresponding cell then sort both the row( ALT+d+s) Sanjay "Sheila" wrote: I need to sort data in a Excel 2003 table while retaining the blank rows in between the data. Every time I perform a regular sort, the blank rows are returned at the end of the table. I need them to remain between each data row. Is there a way to do this? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort data with blank rows dividing data
When I click on the drop down arrows, the only choices I have are Sort
Ascending, Sort Decending, (All), (Top 10), and (Custom). Am I missing something? "phildy" wrote: Select the first row (click on 1 at left hand side). From the tool bar select Data|Filter|Auto Filter A drop down arrow should apear on the first cell in each column. Use one of these drop down arrows and select 'non blank' cells. Sort the cells as required. Use the drop down arrow again and filter to 'all'. Job done. "Sheila" wrote: Sanjay: I don't understand what you're saying. How do I use the filter to select all blank rows? "Sanjay" wrote: Hi Sheila, use filter to select all blank cell and then put any value in corresponding cell then sort both the row( ALT+d+s) Sanjay "Sheila" wrote: I need to sort data in a Excel 2003 table while retaining the blank rows in between the data. Every time I perform a regular sort, the blank rows are returned at the end of the table. I need them to remain between each data row. Is there a way to do this? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort data with blank rows dividing data
Sorry - my error.
Instead of selecting the first row as suggested select all cells by clicking on the grey box above 1. The rest is as before "Sheila" wrote: When I click on the drop down arrows, the only choices I have are Sort Ascending, Sort Decending, (All), (Top 10), and (Custom). Am I missing something? "phildy" wrote: Select the first row (click on 1 at left hand side). From the tool bar select Data|Filter|Auto Filter A drop down arrow should apear on the first cell in each column. Use one of these drop down arrows and select 'non blank' cells. Sort the cells as required. Use the drop down arrow again and filter to 'all'. Job done. "Sheila" wrote: Sanjay: I don't understand what you're saying. How do I use the filter to select all blank rows? "Sanjay" wrote: Hi Sheila, use filter to select all blank cell and then put any value in corresponding cell then sort both the row( ALT+d+s) Sanjay "Sheila" wrote: I need to sort data in a Excel 2003 table while retaining the blank rows in between the data. Every time I perform a regular sort, the blank rows are returned at the end of the table. I need them to remain between each data row. Is there a way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort and sum data range with some blank cells | Excel Worksheet Functions | |||
| How do I delete blank rows (rows alternate data, blank, data, etc | Excel Discussion (Misc queries) | |||
| Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
| How do I create a Macro to sort data and insert blank rows & subto | Excel Worksheet Functions | |||
| Loading Column Data with blank Rows into Data Validation Box | Excel Worksheet Functions | |||
Linear Mode
