To ungroup rows and columns in Excel. Highlight the row or column ... allows users to group rows or columns or automatically create an outline, while ungroup is used to ungroup a range of cells ...