[Solved] Show/hide groups of cells

Discuss the spreadsheet application

[Solved] Show/hide groups of cells

Postby neil-uk » Wed Jul 08, 2020 11:14 pm

Hi Guys,

I've inherited a spreadsheet that was used in Excel.

On doing so I've got these funning little +/- things that hide and show a series of rows.

These are super useful, but I've never used them in Calc before.

What are they called, and can anyone point me to where I can read about using them?

Thanks!
N
Attachments
Screen Shot 2020-07-08 at 10.12.44 PM.png
Last edited by robleyd on Tue Jul 14, 2020 2:39 am, edited 1 time in total.
Reason: Tagged [Solved]; title edited to reflect question
NeoOffice 2.2.3 with MacOS 10.4
neil-uk
 
Posts: 26
Joined: Sun Nov 07, 2010 1:01 am

Re: What is this and how do I do it?

Postby FJCC » Thu Jul 09, 2020 12:41 am

This is done with the menu item Data -> Group and Outline -> Group. You can click the help button in that dialog for a little guidance.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7968
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: What is this and how do I do it?

Postby neil-uk » Tue Jul 14, 2020 2:22 am

Sorry for the delay! Thanks for your help :) added and working.

This is the best thing ever!
NeoOffice 2.2.3 with MacOS 10.4
neil-uk
 
Posts: 26
Joined: Sun Nov 07, 2010 1:01 am


Return to Calc

Who is online

Users browsing this forum: Prometheus76 and 19 guests