![]() ![]() Here’s how: Select any cell in one of the rows you want to group. If your dataset contains just one level of information, the fastest way would be to let Excel group rows for you automatically. How do I automatically group rows in Excel? Otherwise you will be presented with the Group or Ungroup menu. Again, the trick here is to select the entire rows or columns you want to group/ungroup first. Shift+Alt+Left Arrow is the shortcut to ungroup. Shift+Alt+Right Arrow is the shortcut to group rows or columns. What is the shortcut to group rows in Excel?
0 Comments
Leave a Reply. |