Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Data sort seperate by blank row
2 views
Skip to first unread message
Bod
Jan 4, 2010, 10:45:02 PM1/4/10
to
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?
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?
JR Hester
Jan 5, 2010, 4:19:01 PM1/5/10
to
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?
"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
0 new messages