hiding rows based on condition
is it possible to hide rows in excel 365 based on the content of a specific cell?
Sure.
Forum Discussion
Yes; it would require VBA code.
Can you provide more detailed information?
- What is the specific cell?
- Will the value of this cell be changed by the user, or does it contain a formula?
- What are the criteria for hiding rows?
- Which row or rows do you want to hide?
- Can I send excel file here?
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.
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)
