How to Change Grouping Direction Above / Left of Data in Excel?

Today, I have a quick tip for you: Do you want to change the grouping direction in Excel? Usually when you use groupings on rows, the small + or – sign is below the grouped data. The same for columns: The little + and – sign for showing or hiding grouped columns is located on… Continue reading How to Change Grouping Direction Above / Left of Data in Excel?

How To Hide And Group Rows And Columns In Excel

You got an Excel table with some unimportant rows, but you don’t want to delete them. In such case, you might want to “hide” them. There are two options of hiding rows (and columns): Either right-click on the row (or column) number and click on “Hide” or use the group function.

Before you leave: Boost your Excel skills!Join thousands of Excel users & subscribe to the newsletter!
  • The best Excel tips, tricks and tutorials.
  • 1x per month.
  • No spam. Promised.
Welcome gift: Save a lot of time with my huge keyboard shortcut package.

Learn more