Note: For removing the plus or minus sign, please select the rows or columns which you have added plus or minus sign into, then click Ungroup button under Data tab.
And click the Plus sign, the hidden rows or columns are showing at once. Click the minus sign, the selected rows or column are hidden immediately. Then the minus sign is displayed on the left of selected rows, or displayed at the top of the selected columns. 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. Please do as follows to hide or unhide rows or columns with plus or minus sign in Excel.ġ. Hide/unhide rows or columns with plus or minus sign Besides this method, we can hide or unhide rows or columns easily with plus or minus sign in Excel. Normally, we hide or unhide rows and columns by using the Hide or Unhide features from the right-clicking menu.
How to hide/unhide rows or columns with plus or minus sign in Excel?