Grouping

A

Adrian

I have a spreadsheet which we used to be able to group the rows of data which
is not current. In the past, we were able to group these unwanted data and
on the extreme left border whould be a "+" or "-" which allows us to expand
or collapse the rows we wanted to re-use gain etc. Currenty, that border for
the +/- does not appear.
 
R

Ron@Buy

Adrian
I believe this is the SUBTOTAL function that you require.
Search 'Help' for subtotals and look at 'about subtotals'.
Hope this helps
 
C

Cimjet

Hi Adrian
Under menu "DATA" you will find "SubTotals" but also under "Group&Outline"
will give you the feature to group hide/unhide by Rows or Columns or both.
Regards
Cimjet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cut & Paste in Excel without erasing cell borders? 1
Expanding Grouped Rows when sheet is Protected 2
Allowing expanding and colapsing of groups in a protected workshee 1
Expanding and Collapsing Groups within a Protected Workbook 1
Collapsing groups in Macro 7
Expand and collapse 2
Controls collapsed with outline 7
Sorting and grouping data with varying number or rows 1

Top