Subtotals

[grahamcatto]

Hi,
I have inserted subtotals into a list of data by using subtotal function from the Data toolbar in Excel 2019.
The resulting subtotals are not showing any "buttons" to filter the data to the various levels of subtotalling, only the subtotals after the various data splits.
There is only one level of subtotal and the data is from a csv file that represents 11 columns and 631 rows of data (sorted by the 2nd column, the subtotals are based on the 1st column of data)

I have removed and reinserted the subtotals several times but am still unable to see any filter buttons.
Any help would be appreciated.
Thanks
Graham

 

[Peter_SSs]

We can't see the relevant part of your screen, but after you subtotal, don't you have icons like this on the left to hide/show sections/levels?

 

[grahamcatto]

We can't see the relevant part of your screen, but after you subtotal, don't you have icons like this on the left to hide/show sections/levels?

View attachment 107062

That is what my problem is. They are not showing on my worksheet no matter what I do. Never had this happen to me before and I have been using Excel since the 90s. I have just changed employer and using a new Dell laptop with a fresh installation of Excel 2019.

 

[Peter_SSs]

OK, try pressing Ctrl+8 on the keyboard

 

[grahamcatto]

OK, try pressing Ctrl+8 on the keyboard

Thanks Peter, That worked great. All good now. Hopefully when our IT Manager returns from leave tomorrow I will be able to instal XL2BB for future issues.

 

[Peter_SSs]

Thanks Peter, That worked great. All good now.

You're welcome. Thanks for the confirmation.

Hopefully when our IT Manager returns from leave tomorrow I will be able to instal XL2BB for future issues.

Good luck with IT!
It would certainly help if you can get it. If not, in future posts say that you are unable to install XL2BB due to work restrictions. That way people won't keep asking you to do it.

 

[grahamcatto]

You're welcome. Thanks for the confirmation.



Good luck with IT!
It would certainly help if you can get it. If not, in future posts say that you are unable to install XL2BB due to work restrictions. That way people won't keep asking you to do it.

I'm going to instal XL2BB on my personal laptop so if need be I'll generate the query from there.

 

[Peter_SSs]

I'm going to instal XL2BB on my personal laptop so if need be I'll generate the query from there.

Good plan.

BTW, please mark the actual post that answered your question, to help future readers. You have marked a post as the solution that clearly does not contain one.

 

[Peter_SSs]

Thanks Peter, That worked great.

As mentioned in my last post ..

please mark the actual post that answered your question, to help future readers. You have marked a post as the solution that clearly does not contain one.

You originally had post #6 marked as the solution, now you have post #5 marked as the solution. Neither are, so I have now changed the marked post.
No further action is required for this thread.