W
W
webso2018-05-25 15:08:35
excel
webso, 2018-05-25 15:08:35

What is this option in Excel?

Somewhere I clicked something in Excel and the following tools appeared:
5b07fc6e9a505148249587.png
Why is this needed? And how to remove it?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Denis _______________, 2018-05-25
@webso

"Data" tab -> then select the required columns or rows and select the "Ungroup" menu item, select "Columns" / "Rows" in the window, depending on your needs. (there is a "Group" menu item for reverse grouping)
This is used for external design, if rows / columns need to be hidden and then expanded ... the numbers show the level of nesting of such convolutions, if you click on them, it allows you to collapse / expand in whole groups. I think it's a very handy feature.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question