excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Excel 2007

resolvedResolved · Urgent Priority · Version 2007

Faisal has attended:
Excel Intermediate course
Excel Advanced course

Excel 2007

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

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.


 

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)


View all Excel hints and tips


Server loaded in 0.09 secs.