Forum Discussion
Solved
Subtotals in a table
Hello friends. I have a workbook with one page for each account; like groceries, rent etc. The data is already sorted on transaction date; like 1/14/2021 I want to present the data with a break wi...
Hello Hans.
I understand that. I believe I had converted it; but I will double check.
Thanks,
FastEddyG2
Hello Hans.
Thanks for the help. I don't know what I am doing wrong. I followed your very clear "picture" and got a bit further. However, after I "..select any cell.." the subtotal button under outline is grayed out.
Any idea why?
Thanks
FastEddyG2
Thanks for the help. I don't know what I am doing wrong. I followed your very clear "picture" and got a bit further. However, after I "..select any cell.." the subtotal button under outline is grayed out.
Any idea why?
Thanks
FastEddyG2
The subject of your question says "Subtotals in a table".
If your data are in a table (created by selecting Insert > Table), you cannot insert subtotals. Tables don't allow that. So you'd have to convert the table to a normal range. You should then be able to create subtotals.