Oops! It appears that you have disabled your Javascript. In order for you to see this page as it is meant to appear, we ask that you please re-enable your Javascript!

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

Share Post @

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

How to hide columns rows with plus and minus button in Excel. To Hide rows and columns are  common process in excel spreadsheets. Excel spreadsheet ‘s feature 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/column 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.

Summary
How to hide columns or rows with plus and minus button in Excel
Title
How to hide columns or rows with plus and minus button in Excel
Description

How to hide columns or rows with plus and minus button in Excel. Usually we hide or unhide rows and columns by using the Hide or Unhide features of excel. Also we can hide or unhide rows or columns easily with plus or minus sign into Excel. Here I'll show you the details.

Show Buttons
Hide Buttons