Ask Your Question

calc- is there a shortcut to expand/collapse groups?

asked 2019-11-18 05:40:21 +0100

clos911 gravatar image

instead of hitting to 1-2 at the top..

also can the 1-2 be hidden, it looks ugly..

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-11-18 10:48:49 +0100

keme gravatar image

updated 2019-11-18 12:49:49 +0100

No predefined keyboard shortcuts, but there are menu items: Data - Group and outline - Show detail/Hide detail.

Those actions can also be assigned to keyboard shortcuts if you want to.

For the show/hide options to work, current selection (cell range) must touch all columns of a horizontal group or all rows of a vertical group. All groups "fully touched" like this will be affected by the show/hide action. If no group is properly selected, the menu items are greyed out.

To select cells in a collapsed range you can use ctrl-A (which will select the entire sheet) or type an address range into the Name field to the left of the formula bar. If you have named ranges, you can also select the names from that field.

You can hide the outline "branch display": Menu Tools - Options, select LibreOffice Calc - View in the left pane and untick Outline symbols.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-11-18 05:40:21 +0100

Seen: 1,951 times

Last updated: Nov 18 '19