How to hide columns rows with plus and minus button in Excel

How to hide columns rows with plus and minus button in Excel.

Hide rows and columns are a common processes in excel spreadsheets. Excel spreadsheet ‘s features can make the way easier and make it more visible when rows or columns hidden. Grouping inserts small icons around the Microsoft Excel grid to allow us to hide and unhide rows and columns frequently. These icons also identify that rows/columns have been, or could be, hidden. The Group icon is on the Data Ribbon tab.

How to hide columns rows with plus and minus button in Excel

There are two keyboard shortcuts – that should be noted –

To add grouping you select the range and

Press Shift + Alt + right arrow.

To remove grouping select the range and

Press Shift + Alt + left arrow.

Video attached here as below on youtube – How to hide columns or rows with plus and minus button in Excel.

How to hide columns rows with plus and minus button in Excel.