Excel not showing subtotal

[katie200]

Before an update (unknown date), I could highlight the two food items and a subtotal would appear on the sheet page. I know how to total, subtotal, etc. but this was a useful tool with large spreadsheets.

[maniacb]

Right click on that bottom bar and select the options you want to appear in that bar.

[katie200]

I tried this but there are no options showing.

Thank you,

[maniacb]

When referring to the bottom bar, I mean the bottom border of Excel.

[katie200]

Yes, I right clicked on the bottom border of Excel.

[maniacb]

To the right of the macro record?

[katie200]

I'm not using a macro. It is a simple list of expenses.

[maniacb]

I meant that at the bottom left corner of the Excel Window there is a button for "Macro Record." You should be right clicking to the right of that button.

[katie200]

Can you send me a screenshot or excel file that shows this? I don't have any macro button on the bottom bar. Thank you,
Terri

[maniacb]

Look at bar below tab names

gup.png

[katie200]

I appreciate your help. I don't have a bar below the tabs. You don't need to reply. I give up.

Thank you