Problems with Space

[kevs]

I have a heck of a time sorting, when there are swathes of space in my
workbooks. (I mean intermittent rows with nothing there)

For example I often want to sort by e mail so I can delete anyone without an
e mail.

Excel sometimes allows it but usually not. Any tricks for this? Thanks
Kevs



OS 10.4.11
Office 2004

 

[CyberTaz]

Hi Kevs -

Once again you manage to omit the most critical information required for
anyone to know what's actually happening What - exactly - do you mean by:

Sorting is a relatively basic operation if the records are consecutively
listed, so I'm assuming the first statement means that there is no email
address but that there is other data on the row. (If any entire rows *are*
empty you have to select the entire data range in order to sort it.)

Simply because of some of your previous situations I'm further assuming that
the data has been copied & pasted from another source. If so, it is likely
that the email field actually has some sort of content which is in fact
there but may not be visible, so the cell "looks" empty. Therefore the
invisible content is causing those records to fall into different rows than
expected when you sort. See if the Formula Bar provides any clues when you
select one of the "empty but errant" email cells.

I believe there is also a limit to how many records (rows) Excel will
effectively sort - but I can't remember for sure and if so how many.

Unfortunately,

tells absolutely *nothing* about the problem, so if the guesses above don't
hit the target you'll have to provide some specifics:

Do you get an error message - if so what does it display? Does Excel scream
"Rape!!" or what? How are you going about it & what exactly does or does not
happen contrary to your expectations?

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[kevs]

Hi Kevs -

Once again you manage to omit the most critical information required for
anyone to know what's actually happening What - exactly - do you mean by:

Sorting is a relatively basic operation if the records are consecutively
listed, so I'm assuming the first statement means that there is no email
address but that there is other data on the row. (If any entire rows *are*
empty you have to select the entire data range in order to sort it.)

Simply because of some of your previous situations I'm further assuming that
the data has been copied & pasted from another source. If so, it is likely
that the email field actually has some sort of content which is in fact
there but may not be visible, so the cell "looks" empty. Therefore the
invisible content is causing those records to fall into different rows than
expected when you sort. See if the Formula Bar provides any clues when you
select one of the "empty but errant" email cells.

I believe there is also a limit to how many records (rows) Excel will
effectively sort - but I can't remember for sure and if so how many.

Unfortunately,

tells absolutely *nothing* about the problem, so if the guesses above don't
hit the target you'll have to provide some specifics:

Do you get an error message - if so what does it display? Does Excel scream
"Rape!!" or what? How are you going about it & what exactly does or does not
happen contrary to your expectations?

Regards |:>)
Bob Jones
[MVP] Office:Mac

Thanks Bob! Got it, was not selecting the workbook. Now I just click on the
little diamond and bam, works, even selecting the first header row, does not
screw it up as I thought it might.




OS 10.4.11
Office 2004