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

Excel 2007

ResolvedVersion 2007

Tue 16 Feb 2010, 16:22 Delegate Faisal said...

Faisal has attended:
Excel Intermediate course
Excel Advanced course

Excel 2007

Subtotal - is there any way to bold subtotal without doing manually.

Wed 17 Feb 2010, 11:05 Trainer Stephen said...

RE: Excel 2007

Hi Faisal

Thanks for your question

As far as I am aware there is no tool that will automatically format the subtotals created by the subtotals tool. The functionality is not included in the subtotals wizard, and I know of no other way of applying it.

Regards

Stephen

Tue 23 Feb 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips

Excel 2007

Excel 2007

RE: Excel 2007

Excel articles

Excel tip:

No Zeros