| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you create a formula to hide a row if a cell is blank?
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"? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you create a formula to hide a row if a cell is blank?
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"? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you create a formula to hide a row if a cell is blank?
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"? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If/Then Forumla to create blank cell??? | Excel Worksheet Functions | |||
| how to create a formula to hide specific rows after meeting requi | New Users to Excel | |||
| macro to hide rows if cell is blank | Excel Worksheet Functions | |||
| Formula to hide blank rows | Excel Worksheet Functions | |||
| how do i create a blank cell in excel using a formula | Excel Worksheet Functions | |||
Linear Mode
