filtering data and blue marks

T

tara

When I am about to filter some of my data i have, i.e finding all the data
with a certain date, the information appears incomplete and a blue spider or
bug appears
 
M

Max

tara said:
When I am about to filter some of my data i have, i.e finding all the data
with a certain date, the information appears incomplete and a blue spider or
bug appears
Click to expand...

Hazarding some guesses ..

Before re-filtering on a new col,
Try re-setting the Autofilter to show all
Click Data > Filter > Show All

Blue colored row headers are filtered rows (indicative of a filtered
situation). When you reset as above for a fresh filter op on another col,
there should no blue colored row headers (full table, all row headers will
display in normal black colour).
 
Top