Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2003

Thu 5 Feb 2009, 17:15 Delegate Hyacinth said...

Hyacinth has attended:
Excel Advanced course

Excel

how do i put subtotals in?

Fri 6 Feb 2009, 10:05 Trainer Andrew said...

RE: excel

Hi Hyacinth

Thank you for your question.

Click in your data and from the Data menu choose Subtotals. Specify what will trigger the subtotal behaviour and if required where totals should be calculated and click OK.

To remove the subtotal go back to Data > subtotals and click the remove button.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

Thu 12 Feb 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Screen Splitters in Excel

Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.

These icons can be double-clicked to split the screen at the top left of the cell currently in use.

View all Excel hints and tips

Excel

Excel

RE: excel

Excel articles

Excel tip:

Screen Splitters in Excel