Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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.) "Cheryl" wrote: 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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 -- businesslady24 ------------------------------------------------------------------------ businesslady24's Profile: http://www.excelforum.com/member.php...o&userid=35669 View this thread: http://www.excelforum.com/showthread...hreadid=554606 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
"Cheryl" wrote in message
... 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. 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. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Ghost numbers in blank cells | Excel Worksheet Functions | |||
CSV file with 13space characters in blank cells | Excel Discussion (Misc queries) | |||
enter numbers in blank cells | Excel Worksheet Functions | |||
How to alter data on HTML webpage into Excell cells as numbers? | New Users to Excel | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) |