Font Formatting in Excel 2007/2010 - M. S. Excel Tutorials - Science Tutor

Font Formatting in Excel 2007/2010

If you've been following along with the Previous Section, you should now have a spreadsheet that looks like this:

Excel 2007 to Excel 2013 have a much wider range of formatting options than previous versions, and it's relatively easy to turn a dull spreadsheet into something that really shines. We'll start with changing the font.

Choosing a Font in Excel 2007/2013

You can pick a different font for the data you enter into cells, as well as choosing the size you want. The colour of the font, and the cell background, can be changed, too. From Excel 2007 onwards, Themes have been introduced, so that you can format your spreadsheets more easily. You'll meet these later. First, we'll see how to change the font type.

• Highlight cell A1 on your spreadsheet by simply clicking into it
• Locate the Font panel on the Excel Ribbon at the top of the page:

The font in the panel above is set to Calibri. To see more fonts, click the black down arrow:

The good things about Excel 2007 and 2010/2013 is that when you move your mouse over one of the fonts on the list, the text in your selected cell (A1) will change automatically. This is just a preview, though. When you have decided on the font you want, click it with the left mouse button.

You can change the size of the font in the same way - just choose a new font size from the list of numbers in the drop down box.
If you want to change the font via the Format Cells dialogue box, as you did in previous versions of Excel, you can click the small arrow in the bottom right of the Font panel (the one circled below):

When you click the arrow, you'll see the Format Cells dialogue box. You can choose various options from this dialogue box: Font size, style, size, etc. The dialogue box looks like this:

You can also set the font colour from here, and add text effects. Click OK when you have made your choices.

When you have changed the font and font size, your A1 cell might look something like this:

The background colour of your cells can be changed, too. We'll see how to do that in the next section.

Copyrights (C) - Science Tutor - Smart Study Anytime Anywhere