How do you hide rows that have cells that are blank

F

Frank Kabel

Hi
one way (without using VBA). If you have a heading row try the
following
- select your heading row
- goto 'Data - Filter - Autofilter'
- In the columns of your choice click on the filter listbox and choose
'non blanks'.
 

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

Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
How to have two tables on same line? 1
Hide columns based on row values 2
Eliminate blanks while copy row and transpose 11
Count NonBlank Rows with Criteria in another column 7
How do I filter data by more than one column in excel 0
count nonblank cells 3
Autofilter:How to determine if the func returned no matches 1

Top