Excel 2007 missing data using auto filter

E

eth

I have activated my DATA - Filter. It is not displaying all different types
of items within the column. I have about 1600 rows of data. Not all rows
have an entry. The first data I am missing appears on row 504. I have
tried reformat the cells to make sure they are general formatting. Any
thoughts?
 
S

Squeaky

Hi Eth,

Something I try is to do a drag/copy of the cell above it (or one that I
know that has data that is recognized) so it copies its formatting, then
rewriting the proper number back into that cell. If that works then it is
probably a formatting issue.

Squeaky
 

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

Force a filter beyond blank rows 1
Using Filter more than once 2
Auto-filter not grabbing all the data 2
Data - Filter - Auto Filter 1
Auto Filter Help 2
Problems with Auto Filter 2
questions on advanced filter 4
Auto-filter selection 1

Top