Unit 10: Font Formatting

A worksheet or workbook that is simply screens and screens of plain text and numbers can be, to say the least, dead boring. You can greatly improve the readability of your worksheets, emphasizing key data and perhaps downplaying less-than-glamorous data, by formatting the cells in the worksheet and changing the look, feel, color, and size of the fonts. In computer jargon formatting means changing the appearance of data without changing the underlying value of it. Excel provides a rich array of tools for jazzing up your worksheets. Font formatting refers to the process of changing the appearance of the numbers and text in your worksheet. Font formatting can be used to make your data easier to read and comprehend, and generally more appealing to look at than just a series of bland numbers and words. Font formatting can also be used to draw attention to or away from key elements in your worksheet.

Font is a general computer term and refers to the style, size and even color of the text and numbers in your worksheet. There are many different font styles available and they have been given all sorts of names such as Calibri, Arial, Bodoni, Rockwell, Script, and the like. No matter what you type into a worksheet it will need to have a font style – the default, if you don’t choose anything else, in Excel is Calibri. Font styles are installed on your computer and are available to any application, including Microsoft Excel, that you should choose to use. In addition to the style of font you can also change its size, making it bigger or smaller as required, and generally its color. Finally, many font styles have attributes such as bolding, italics and underlining that can also be applied.

The Tools for Formatting Fonts

Watercolor Handy Tools Clipart Set | Pre-Designed Photoshop Graphics ~ Creative MarketFont formatting is done using the normal point and shoot methodology of Excel – in other words, you select the cell or range to change, then make the changes. You can make font formatting changes in a variety of ways. You can change the fonts by:

  • using the commands in the Font group on the Home tab of the Ribbon.

  • using the options on the Font tab of the Format Cells dialog box.

  • right-clicking and using the mini-toolbar that appears with the shortcut menu.

It doesn’t much matter which of tools you use apply your formatting although you will find occasion to use a variety of them since not all of the options can find entirely in one of these locations.

UNIT 10 – Font Formatting


There aren't any posts currently published in this category.