PC Review


Reply
Thread Tools Rate Thread

Data sort seperate by blank row

 
 
Bod
Guest
Posts: n/a
 
      5th Jan 2010
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 With Quote
 
 
 
 
JR Hester
Guest
Posts: n/a
 
      5th Jan 2010
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro To Sort and Seperate Data on Serpate sheets from a Master Li Troy Microsoft Excel Programming 15 29th Aug 2009 09:56 PM
Sort data with blank rows dividing data Sheila Microsoft Excel Misc 5 21st Nov 2008 06:54 PM
Automatically duplicate and sort data into seperate w.sheet =?Utf-8?B?VGluZw==?= Microsoft Excel Misc 1 21st Jun 2006 02:14 AM
Sort out data on seperate sheet =?Utf-8?B?TGluZGE=?= Microsoft Excel Programming 11 13th Jun 2006 06:10 PM
SORT/SEPERATE DATA Jill Microsoft Excel Misc 4 19th Feb 2006 02:14 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:24 AM.