Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data sort seperate by blank row
Hi!
In the past when I have done a data sort, the block of cells has been confined by 1) a column which doesn't contain a header row and 2) a blank row. I want to use this feature but today, Excel has decided it will ignore the blank row and act as if all rows are one block. This seems inconsistent - I was relying on inserting a blank row to deal with each block of cells seperately as I have done in the past. Does anyone know what I need to do to get Excel to act as it usually has done? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data sort seperate by blank row
You need a complete column and/or row of empty cells to keep Excel from
"jumping teh fence" when sorting blocks of data. Be careful about those empty columns-- are you sure you don't want that data to stay with the block being sorted? HTH "Bod" wrote: Hi! In the past when I have done a data sort, the block of cells has been confined by 1) a column which doesn't contain a header row and 2) a blank row. I want to use this feature but today, Excel has decided it will ignore the blank row and act as if all rows are one block. This seems inconsistent - I was relying on inserting a blank row to deal with each block of cells seperately as I have done in the past. Does anyone know what I need to do to get Excel to act as it usually has done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort data with blank rows dividing data | Excel Discussion (Misc queries) | |||
sort and sum data range with some blank cells | Excel Worksheet Functions | |||
Automatically duplicate and sort data into seperate w.sheet | Excel Discussion (Misc queries) | |||
SORT/SEPERATE DATA | Excel Discussion (Misc queries) | |||
How do I seperate data from a pivot into seperate worksheets? | Excel Discussion (Misc queries) |