Can you create a formula to hide a row if a cell is blank?

G

Guest

I am copying cells from several worksheets (same array copied from each
worksheet, for example A3:E10) in sequence into one worksheet, but do not
want to display cells that have no data. Is there a way to hide rows in the
new worksheet if the copied data is blank? Is there a formula command for
"hide row"?
 
G

Guest

To specifically answer your question: No, no worksheet function to
hide/unhide rows or columns. Consider what Barb offered.
 

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 Copy cells from one worksheet to another workseet - increment row & do again 0
How To Have A Cell Be Blank If... 2
auto hide blank rows 1
hide a row 2
copy data from one worksheet and disregard blank cells 6
Hide row if all cells in another range are blank 2
How do I prevent data i a cell from being copied? 2
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2

Top