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

Automatic Emails sent to my Contact Groups by Microsoft 1
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
How To Have A Cell Be Blank If... 2
Merging from an Excel file with graphics 1
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
REINSTALLING MS OFFICE PRO PLUS 2019 0
Publisher is filling blank lines with data 2
Comparing columns of data? 0

Top