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

's Computer Specifications

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"?

's Computer Specifications

Why not use AutoFilter and hide the blanks.
--
HTH,
Barb Reinhardt

"Eileen" wrote:

> 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"?

's Computer Specifications

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

"Eileen" wrote:

> 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"?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Average Formula to display blank cell if named range is blank	Rachael F	Microsoft Excel Worksheet Functions	3	22nd Feb 2008 05:05 PM
How to create a formula that results in a blank cell if required	Martin C	Microsoft Excel Discussion	7	17th Jan 2007 04:55 PM
Formula to hide blank rows	=?Utf-8?B?TGFkeXJh?=	Microsoft Excel Worksheet Functions	4	25th Feb 2005 06:55 PM
how do i create a blank cell in excel using a formula	=?Utf-8?B?VG9zaA==?=	Microsoft Excel Worksheet Functions	1	2nd Nov 2004 04:22 PM
VB- If first cell with formula is blank, all cells in column returns blank.	mnhesh	Microsoft Excel Misc	2	12th May 2004 05:14 PM