Autofilter a list of numbers and blank cells

C

Cheryl

My report consists of a list of numbers and blank cells in column B and
descriptions in column A. I would like to print the report showing only the
list of numbers in column B and relevant descriptions in column A. Filtering
does not work if the list consists of blank cells in between. thank you
 
T

tim m

This might not be the most efficient way of doing it but I usually will sort
all of the data, this will stick all the blanks at the bottom. Then I just
hilite the cells with data and 'print area'...'set print area'
(If the cells with data need to be in a specific order, before the sorting
to lump the blanks together I will quickly insert a column and data fill it
so I have numbers that I can sort back to.)
 
B

businesslady24

Hi,

If you are using autofilter on your columns, you should be able to
select 'non blanks' from the drop down list. This will omit all blank
cells in column B and only show the relevant data in column A that
corresponds to those cells that are left in column B

HTH
 
D

David Biddulph

Cheryl said:
My report consists of a list of numbers and blank cells in column B and
descriptions in column A. I would like to print the report showing only
the
list of numbers in column B and relevant descriptions in column A.
Filtering
does not work if the list consists of blank cells in between.
Click to expand...

Yes it does. Select the whole list (columns A & B, top to bottom). Data/
Filter/ Autofilter
Hit the filter button for column B and select Non-blanks.
 
Top