Data sort seperate by blank row

B

Bod

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?
 
J

JR Hester

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
 

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

How To Have A Cell Be Blank If... 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Concatenate with line breaks but ignore blank cells 3
Sorting by rows with differing numbers of cell entries 3
Sort data with blank rows dividing data 5
Insert Row 2
Filters will not include cells beyond the first blank? 4
Insert Blank Row with data match change 1

Top