These two options control the font face and size. By selecting a cell or range of cells and then using theseįormatting toolbar options, you can select a different font and/or make theįont bigger or smaller, depending on your needs. Two options on the formatting toolbar control the font face and size in your
Use the formatting toolbar to change the font Two ways to change the font in Excel: (1) use the Formatting toolbar or (2) use When usedĪppropriately, fonts are a really easy way to make your work look good and Font face, style, and sizeĮver used a word processor, you probably know all about fonts. More options on the Formatting toolbar, some of which will be discussed later For example, 10,000.05 becomesĭecimal place from a number. The number in the cell and adds a percent sign to the end of the number.Ĭomma and two decimal places to the number.ĭecimal place to a number. Numbers are automatically right-justified when you put them
Right-justifies the number in the cell and adds a dollar sign and twoĭecimal places. Text up with the right-hand side of the cell. Text up with the left-hand side of the cell. The size of the text in the selected cell or range.
TableĪ below outlines the Excel default styles that are available from theĪn example of the results of some of the buttons on theĭrop-down arrow next to the font name to see a list of the fonts availableįor you to use in the selected cell or cell range. To use one of theīuttons, select the cell, or range of cells, that you wish to format and thenĬlick the desired button on the toolbar. The various buttons on the Formatting toolbar accomplish. Used other Microsoft programs, you’re probably familiar with the use of the The end of the next three articles in this How do I… series, you’ll be Before you startįormatting your spreadsheet, it probably looks like a bland table of numbers. In this How do I…, and in future articles, series, you’ll learn to do these things, and more. Some things stand out? Maybe you’d like to easily turn some values into dollarįigures or have Excel automatically highlight an inventory line for which you’ve Before you submit it to your boss, wouldn’t it be nice to make Now, perhaps you’veĬreated a useful spreadsheet, complete with formulas that calculate sales of
You’ve learned how to create some rudimentary formulas. Point, you’ve probably learned about the basics in Microsoft Excel, and
A downloadable PDF version is also available. This article was orginally published on September 9, 2005. Properly formatting a spreadsheet can bring a project home.
This series of Excel tutorials can make that training much simpler. While Microsoft Excel may be familiar to you, if you are on a help desk, you will have to explain how the application works to users who fall within a vast range of skill levels and knowledge. Sometimes, we take for granted what users know.