Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.
A common query we have is how to remove the Grouping feature from rows or columns in Excel spreadsheets.
Simply highlight the rows or columns that you want to change, click on the DATA tab and then look for the UNGROUP button in the OUTLINE section.
The groupings will be removed. You may need to do this a few times if there are nested groupings.
Extra MS Excel Tip
Did you know that you can copy/ paste a section of Excel into Word WITHOUT still seeing the gridlines, filter buttons and more!
Watch how to Remove gridlines from Excel paste as picture (opens in a new tab) on our YouTube channel (don’t forget to subscribe).