Make your own list – like the months in the year [VIDEO]

A Custom List Can Stop Entries Being Missed

Make Your Own Lists like January, February etc

When you drag a cell with January in it with the fill handle (the small cross at the bottom right corner of the cell), Excel creates a series with February and March etc. This is quick and useful. It also works for days of the week. Eg drag a cell with Monday in it to get Tuesday, etc. This is an example of a custom list.

Copy formats quickly with the Format Painter

Do you know the mouse trick?

One of Excel’s most useful Ribbon / toolbar icons is the Format Painter.

To use it first select a cell or range that has the format you want to use. Then you click the Format Painter icon and click another cell to apply all the formats that the original cell had.

Welcome to the Excel Yourself Blog

Do you know everything about Excel?

I’ve been using it for over 20 years! I’ve learned a lot in those years, but I’m still learning new things and this blog aims to share my knowledge. Of course new versions are always adding new features, so it can be hard to keep up.

I’m a CPA and this blog will discuss Excel topics that are directly applicable to Accountants and Finance staff. The content will vary from simple to complex; from functions to formatting; from Excel 2003 to Excel 2010.