Ask Your Question

easy way (short cut) to hide and show rows?

asked 2019-10-16 17:38:11 +0100

CRB001 gravatar image

updated 2019-10-16 17:45:42 +0100

Is there a short cut to hide and show rows in libre office calc. I know and understand how to perform the action by selecting rows and right click. It would save so much time if I could predefine selected rows to hide and show, then have a short cut to show and hide those predefined cells thereafter.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-10-16 19:26:40 +0100

Opaque gravatar image

updated 2019-10-16 19:36:36 +0100


the method for this is called Group and Outline and can be reached via Data -> Group and Outline. If you select some rows and select Data -> Group and Outline -> Group then a + symbol appears left to the row numbers. Clicking toggles hide and show

Note: You may customize keyboard shortcuts (or use the existing ones, if not aleady used by your operating system) to easily define and remove those groupings.

Hope that helps.

edit flag offensive delete link more


What a legend, thank you so much.

CRB001 gravatar imageCRB001 ( 2019-10-17 15:44:07 +0100 )edit

If you find the answer correct or helping you to solve your problem, please click the check mark (✔) next to the answer.

BTW: This also works for columns.

Opaque gravatar imageOpaque ( 2019-10-17 17:38:20 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-10-16 17:38:11 +0100

Seen: 93 times

Last updated: Oct 16 '19