Forum Discussion
Solved
hiding rows based on condition
is it possible to hide rows in excel 365 based on the content of a specific cell?
Sure.
I have three pages in the “Sheet1” of the "test3" excel file, I need to create four buttons to:
- Button 1: display and print Page 1 only and hide blanks cells "if found" based on the content of cell “A” , (if it includes a name or not in each row)
- Button 2: display and print Page 2 only and hide blanks cells "if found" based on the content of cell “A” , (if it includes a name or notin each row)
- Button 3 display and print Page 3 only and hide blanks cells "if found" based on the content of cell “A” , (if it includes a name or notin each row)
- Button 4: display all pages and hide blanks cells "if found" based on the content of cell “A” , (if it includes a name or notin each row)
Where do you want the buttons? We can't place them next to one of the three pages because they might be hidden?
ca you put it at the first row starting from C1 before the row of student name and degree?
But buttons 2 and 3 will hide page 1...
- choose suitable places for them