隐藏基于单元格内容的行 - Google电子表格(Hide Rows Based on Content of a Cell - Google Spreadsheet)

 如果Google电子表格的单元格中存在特定值，我想创建一种隐藏特定行数的方法。 
 
 例如 
 
         A                   B
1   Include All options`?       Yes/No
2   Option A:                   Yes/No
3   Option B:                   Yes/no
etc.
 
 如果单元格B1为“是”，则不需要查看所有其他选项。 但是，如果他们选择“否”，则需要选择“是/否”选项。 出于这个原因，我想在option = yes时隐藏行，但是如果它为No则取消隐藏它们 

I want to create a way to hide a certain number of rows if there is a certain value in a cell of a Google spreadsheet.
 
E.g.
 
         A                   B
1   Include All options`?       Yes/No
2   Option A:                   Yes/No
3   Option B:                   Yes/no
etc.
 
If cell B1 is "yes" there is no need to look at all other options. However, if they select "No", there needs to be an option for selecting the Option "Yes/No". For this reason, I would like to hide the rows when option = yes but unhide them if it is No

原文：https://stackoverflow.com/questions/29118719