Forum Discussion
ajl_ahmed
Jul 11, 2022Iron Contributor
hiding rows based on condition
is it possible to hide rows in excel 365 based on the content of a specific cell?
- Jul 11, 2022
Sure.
HansVogelaar
MVP
Do you see an area below the reply box with "Drag and drop here or browse file to attach"? If so, drag your workbook into that area.
Otherwise, you can upload the workbook to a cloud service such as OneDrive, Google Drive or Dropbox, share it and post a link to the shared file in your reply.
ajl_ahmed
Jul 11, 2022Iron Contributor
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)
- HansVogelaarJul 11, 2022MVP
Where do you want the buttons? We can't place them next to one of the three pages because they might be hidden?
- ajl_ahmedJul 11, 2022Iron Contributor
ca you put it at the first row starting from C1 before the row of student name and degree?
- HansVogelaarJul 11, 2022MVP
But buttons 2 and 3 will hide page 1...