Filter-----Help

A

acss

I have a workbook of invoices column A has name of company and column D has
amount. When applying a filter to column A which contains the name then the
rows 22 thru 360 appear as they contain the data however when the filter is
taken off the rows 353 thru 360 disappear. What could cause this to happen???
 
R

Ron de Bruin

Hi acss

Then there is a empty row in your data
Excel guess what the range is and it will stop if it see a empty row or column

Turn off Autofilter
Select the whole range
Turn on auto filter
Try again
 

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
Filtering unique combinations of cells 7
questions on advanced filter 4
How do I Copy and Paste onto Same Rows after filtering out rows. 2
help with filtering 2
My filter does not pick up all text 5
Filter is slow 1
Filter (blanks) with two or more unique values not working 1

Top