> I have normal worksheet for class attendance, first column (A) has
> student names, next column (B) has countif formula, remaining columns
> have date labels and X for present and A for absent.  I copied names
> from webpage and pasted into excel, then used paste special using
> multipy x 1 to remove hyperlinks property from names in column A.
> Everything seems to be fine.  I've done this in the past and never
> noticed any problem.  But over the past couple of day, I've come to
> discover that I am unable to get the autofill/copy pointer
> (crosshair)from the botton right corner of the cells in Column A (or
> column B) that contain names.  What I get instead is the 4-headed
> arrow pointer.  As I click on the bottom right corner of the cell, I
> end up selecting a hidden object which I can then resize.  The problem
> is I can select the object and delete it but there appears to
> different amount of objects layered on top each other for each cell.  
> I have to delete all the objects before I am able to obtain the
> autofill pointer.  I tried using the clear command but all is does is
> clear the cell not the objects.  It's hard for me to explain what the
> problem is in words so I am attaching a printscreen of the problem.  
> Has anyone ever had this problem before, is there an easy way to fix
> it, and how do I avoid this in the future?  My only guess is that
> there's something that happens when I remove the hyperlink formatting
> from the names by using the paste special multipy x 1 trick...but that
> doesn't explain why column B has the same problem though.  Thanks for
> your time and appreciate any help you can give.
>
> Ed