calc- is there a shortcut to expand/collapse groups?
instead of hitting to 1-2 at the top..
also can the 1-2 be hidden, it looks ugly..
First time here? Check out the FAQ!
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.
Asked: 2019-11-18 05:40:21 +0100
Seen: 1,951 times
Last updated: Nov 18 '19
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]