| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide rows if "0"
Hey Bruce: Perfect!! :-)
-- Therese "bpeltzer" skrev: Two possibilities. First, you can embed the link inside a formula to detect a blank cell and replace it with a blank rather than bring back a 0: instead of =SheetB!A1, use =if(isblank(SheetB!A1),"",SheetB!A1). Second, you could simply use a filter. Select the table on sheet A. From the menu bar, Data Filter Autofilter. Use the drop-down in the appropriate column and select 'Custom'. Use the drop-downs in that dialog to select 'does not equal' 0. When you click OK, those rows that had 0 in the selected column will be hidden. Is that what you're looking for? --Bruce "Therese" wrote: I have some data linked from spreadsheet B to spreadsheet A in the same workbook. Sometimes the numbers show, sometimes they don't depending on the results on spreadsheet B. Now I'd like to hide the rows automatically on spreadsheet A if the result is "0". Is this possible at all, and if so - how. Thanks in advance -- Therese |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the quickest way to hide a lot of rows and colums ? | Excel Discussion (Misc queries) | |||
| how to hide rows in a protected sheet | Excel Worksheet Functions | |||
| Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) | |||
| AUTO HIDE ROWS | Excel Worksheet Functions | |||
| Excel - if cells = 0, how to conditionally hide rows in chart | Excel Worksheet Functions | |||
Hybrid Mode
