Excel’s Group and Ungroup feature is very useful and should used rather then the Hide/ Unhide feature. It is easy to do. Highlight the rows or columns, click on DATA tab and then GROUP (or UNGROUP) if you want to remove them.
A common question is whether the plus and minus icons can appear above the hidden items instead of below.
YouTube Move the Group button to the top/ left
The answer is yes. Once you have setup the grouping, click on the settings button
Untick the ‘Summary rows below detail’ (or one of the other options).
To see how to do the Grouping you can watch the video clip on the Group/Ungroup video tutorial page
Related-View our course on cleaning data with Excel