Shortcuts for formatting

There’s very little formatting, so I’ll use a number of shortcuts to clean thing up.

First, I’ll turn off gridlines to make borders easier to see.

I want to change all text to a dark gray to match the chart.

SO I’ll select all, then use Format Cells.

Also, the Format Cells dialog lets you format almost anything in Excel, including charts and other objects.

Next, I’ll add borders.

For the headings, Center Across Selection is a nice trick that avoids problems that come with merging cells.

These shortcuts toggle formatting on and off.

To apply currency format, I’ll use control + shift + $.

I cover all shortcuts for number formatting in a separate video.

Because there is no dedicated shortcut to set decimal places.

I’ll use Format Cells.

For left alignment, use Alt H + AL in Windows, Command L on a Mac.

For right alignment, use Alt H + AR in Windows, Command R on a Mac.

Finally, just a quick tip: the Format Cells dialog box remembers that last tab that you used.