View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Anne Troy
 
Posts: n/a
Default corrupt program or file? How to tell? Or is it operator error?

No. Blank CELLS are okay, but no "completely" blank rows or columns is the
rule.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

wrote in message
oups.com...

Anne Troy wrote:

NO extra (blank) rows and NO extra (blank) columns in the data. If you
delete a name, delete the entire row, not just the contents of the cells.
When you have blank rows or columns WITHIN your data, the sort ranges
CHANGE.


Thanks. I know the leave some of the various categories blank for
different clients. Will that apply in any row? perhaps they should just
leave a character in there for unknown or NA.

And it is possible that they might accidentally delete names. I don't
think they leave any of those blank intentionally, but it wouldn't
surprise me if they click on it, and then do something else, not
realizing the error.