WebOct 17, 2011 · If you mean you want to hide all the rows containing HIDE THIS ROW, then this can simply be done using the filter option in the Data Tab. It will add drop down buttons to the column heading and allow you to hide them by removing the tick agains the item HIDE THIS ROW. If you mean hide pages then you will need to use some form of macro? Web1. Select the entire rows or columns you need to hide or unhide with plus or minus sign, then click Group in the Outline group under Data tab. See screenshot: 2. Then the minus sign is displayed on the left of selected rows, or displayed at the top of the selected columns. Click the minus sign, the selected rows or column are hidden immediately.
How to hide/unhide rows or columns with plus or minus sign in Excel?
WebSep 29, 2015 · Alt-Q to close the VBA editor and return to Excel. Alt-F8 to open the macro window. Select HideRows Run. If you wish to hide/unhide rows dynamically, as cells are populated or cleared, having run the above macro, try as follows: Right-click the sheet tab. Select the View Code option from the resultant context menu. WebA better way would be to use a helper column of values: filter by each color, fill the extra column with words (red, white, blue) or numbers (1, 2, 3) that correspond to the filtered color, then use filtering on that new column to hide the red rows. HTH, Bernie. 2 people found this reply helpful. ·. ontario service ontario phone number
VBA Macro to Hide All Columns That Contain a Value in a Cell
WebFeb 15, 2024 · Embed VBA to Hide Rows Based on Cell Text Value in Excel Suppose you want to hide rows that hold a specific text value in a particular cell. In our case, we will give you an example with the row that contains the word “ Chemistry ” in Cell D6 and provide you with the code on how to hide that row, row 6 based on the text. Steps: WebHide rows based on cell value with Kutools for Excel 1. Select the data range and click Kutools > Select > Select Specific Cells. See screenshot: 2. In the Select Specific Cells dialog, check Entire row under Selection … WebHide columns. Select one or more columns, and then press Ctrl to select additional columns that aren't adjacent. Right-click the selected columns, and then select Hide. Note: The double line between two columns is an … ontario service license renewal