Formatting cells in Excel with currency

When I add financial data to my worksheets, I generally type in the content and format the cells afterwards – here are two ways to format cells with currency.

I select my active cells, then I then click on all the cells, right click on format cells, and then go through the dialogue box to select “currency”, then 2 decimal places….I then use the fill handle to copy the format into the remaining column.

Formatting cells using the Format Cells dialogue box

This works as a process, but I can make this quicker using the currency button in the Home tab.  I select the cells, then go to the Home tab, Number section, and select the currency button.

Currency button adds the format in one click. Nice.

I achieve the same result but in a quicker way.

For syllabus information on our courses from introduction to Excel VBA Courses London