losing rows when sorting in excel

D

Diane

I use a particular spread sheet month after month by
copying it and then changing certain items and resorting
it but time after time I have noticed that I am missing
rows each month. I am not hiding them so that's not the
problem. The rows (and it's random from one month to the
other) just seem to disappear. I don't know that they
are gone until I realize that the customer know longer
exists (if they call me and ask me to look up something
on their account that month). So, it's a real problem
because I never realize they are gone unless I need to do
something specifically with their account. Any ideas on
what it could be and how to fix it? Thanks...
 
E

Earl Kiosterud

Diane,

Strange. Sorting in Excel can mess up data, but not make it disappear.
Look for discontiguous row numbers in the row header, indicating hidden
rows. Try selecting all cells (Ctrl - A, or click the intersection of the
row and column headers), then right-click and Unhide.
 
G

Guest

I did check to make sure that nothing was hidden. I
guess this is not of the norm, right? Can you think of
what could else could do this or another way to go around
it? Thanks, Diane
 
Top