Making Subtotals Bold

When you use the SUBTOTAL feature in the Data ribbon tab it automatically inserts subtotals in your list – see blog post on it here.

One problem with this is that is only makes the cell with the word Total bold – it doesn’t make the whole row bold.

If you want the whole row to be bold it isn’t hard to fix.

  1. Select the whole range involved.
  2. Use the grouping button 2 top left corner. See image below.
  3. Then hold the Alt key down and press the ; (semicolon key) – this selects just the visible cells.
  4. Then press Ctrl + b to bold it.
  5. Click another cell to reset the range and you are done.

Learning Excel’s Function Arguments

When you start to use a function it can take some time to learn the arguments required and understand what Excel expects for each argument. Eg should it be a cell or a range or either?

When you have the start of a function in the formula bar, you can either press Ctrl + a or click the fx symbol on the left of the formula bar – see image below.


In the image above, the argument in square brackets [range_lookup] is optional. Square brackets around an argument mean it is optional.

This will display a dialog with a listing of the arguments required by a function. The bold names are required, the non-bold names are optional.


This listing provides a lot more detail on what Excel is expecting for each function argument. This helps you learn more about how to create and use the function.

[related_posts_by_tax taxonomies="category,post_tag"}

Summing a range with Errors

If you have a column of values with errors, but you want to see what the values add up to, use the AGGREGATE function (added in Excel 2010).

If column A has the values and errors use


The 9 means SUM. The 6 means ignore errors.

Financial Model Guidelines


“A new financial modelling guide authored by the ICAEW Corporate Finance Faculty and RSM aims to help businesses of all sizes plan and reduce risk. ” – website

If you use or build financial models then this pdf guide may be worth downloading – its free and no email is required – at least when I downloaded it.

Happy reading.

Don’t forget you can read pdfs on your kindle and iPad.