Bold Your Headings

Apparently this is not widely known, but you should always bold the headings in your tables.

Then when you use Format as Table (Ctrl + t) on the Home ribbon tab the header row will be correctly identified.

This also applies to the Ctrl + Shift + L shortcut to insert the filter drop downs.

It also applies to the ranges used for charts.

In general ALWAYS BOLD your headings – it is something Excel looks for.

Ctrl + b is the bold shortcut.

Related Posts

Atomic Habits (2018)

A new book that covers how you can make small incremental changes over time that lead to large results.

Atomic means small, as in atoms.

I have followed James’s Blog (link below) for a number of years and this book covers topics from the blog plus new material.

James Clear’s blog

His back story is interesting and inspiring.

It is a practical book and he provides ideas to increase your good habits and reduce your bad habits – useful strategies to do both are included.

Habits are automatic and many times unconscious, so the more automated and intentional you make your habits the more time you have for other important things.

You may need to read it a couple of times to get the most out of all his suggestions.

Highly recommend.