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.
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.
View Comments
My brother recommended I might like this website. He was entirely right. This post actually made my day. You can not imagine just how much time I had spent for this information! Thanks!
Thanks to your brother, and welcome you to our blog.