Font and format properties

Excel’s default font setting got changed now. Obviously you can manually choose your desired font each time you start a new worksheet, but that’s a hassle.
In Word, you can change the default font via the font settings window, which is logical. However, when you access the same area in Excel (which you can do by pressing Ctrl-Shift-F), you’ll find no such option.
Fortunately, it’s not difficult to make the change if you know where to look. (Note that this info applies to Excel 2010 and 2013; I’m not sure if it’s the same in earlier versions.)


How to change:

1. Start Excel and open any new or existing workbook.
2. Click File, Options.
3. In the General section, look for “When creating new workbooks.” The very first option: “Use this as the default font.” Choose the font you want, then click OK. (You an also modify the default font size if you want.)


Change the font size in a cell:

1. Select the text that you wish to change the size of. This can either be the entire cell or only a character in the cell.
2. Select the HOME tab in the toolbar at the top of the screen and select your new size in the Font group.
3. The selected text should now reflect this new font size.


Additional formatting option:

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) or pressing right button and then select format cell option.

When the Format Cells dialogue box appear. 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 color from here, and add text effects. Click OK when you have made your choices.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>



clearPost Comment