IF you do not like to enable Filter function, neither to VBA, here I introduce you a handy tool – Select Specific Cells of Kutools for Excel to quickly select entire rows based on cell value, then you can hide them. Hide rows based on cell value with Kutools for Excel With Kutools for Excel's Select Specific Cells, you can select cells based on one or two criteria once time.ģ00 handy Excel add-ins, free to try with no limitation in Quickly select cells based on criteria in Excel = Rng.Value xNumber, or if you want to hide rows whose data is equal to 3000, change to = Rng.Value = xNumber. XNumber = Application.InputBox("Number", xTitleId, "", Type:=1) Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8) Then click Insert > Module to open a new Module window, and paste below VBA code into it. Press Alt + F11 keys to enable Microsoft Visual Basic for Applications window.Ģ.
Moreover, if you are interested in VBA code, here I can introduce a VBA code to hide rows based on cell value.ġ. Now the only the data greater than 3000 is shown, and the rows whose data is smaller than 3000 are hidden. In the popping dialog, type the criterion into the textbox next to is greater than. Then click on the down arrow to display the filter drop down list, and click Number Filters (or Text Filters) > Greater Than (you can choose other criterion you need from the submenu). Select the data you want to filter out, and click Data > Filter. In Excel, you can use the Filter function to filter and hide the rows based on cell value.ġ. Hide rows based on cell value with Filter (3 steps)Hide rows based on cell value with Kutools for Excel (5 steps)Hide rows based on cell value with VBA (4 steps)Hide rows based on cell value with Filter
0 kommentar(er)
