Скачать или смотреть Grouping Rows and Columns

Hiding columns can make your worksheet cleaner, but it can also make navigation tricky, especially if you forget what’s hidden. A better approach is to group columns—this way, you can collapse or expand them whenever needed without losing track.
Here’s how to do it:
1. Select the columns you want to group.
2. Press Shift + Alt + Right Arrow (Windows) or Option + Command + K (Mac) to create a group.
3. A small “–” (minus) button will appear above the grouped columns. Click it to collapse the group, turning it into a “+” (plus) button that you can click to expand again.
This method keeps your data organized and easily accessible while letting you hide details only when necessary. Same goes for columns – no more hiding, just grouping!