filtering data and blue marks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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).

---
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table macro filter data between yesterday and today (date+time) 0
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 2
Merged cells disturb autofilter indicator 2
Data validation list & vlookup 4
auto filter on columns 2
Referncing Rows of Filtered Data 8
Dynamically sized table compiled from unsorted rows with blank entries 2
Missing Filtered Data 1

Back
Top