Follow the steps below to group and ungroup rows and columns in Excel. On the left of the spreadsheets, you will see buttons that you can use to hide the section you have grouped or unhide it.

The theoretical limit of rows and columns in the Microsoft Office application Excel is well defined. If you exceed this mark, you are prompted with a ‘File not loaded completely’ popup message.