Using the “ Auto Outline,” we can automatically group the data.ĭid you notice one special thing from the above image?
So, what would be your reaction if we say you can group with just one click?Īmazing. The only problem with the above method is that we need to do this for each state individually, so this takes a lot of time when there are many states.
In the above, we have seen how to group the data and row with expanding and collapse options using the “PLUS” and “MINUS” icons. To group these rows, we must press the shortcut key “SHIFT + ALT + Right Arrow key. The shortcut key to group the data is “ SHIFT + ALT + Right Arrow key.”įirst, we must select the rows that need to be grouped. read more, we can easily group selected rows or columns. With a simple shortcut in excel Shortcut In Excel An Excel shortcut is a technique of performing a manual task in a quicker way.