Microsoft Excel 2003 provides several formatting tools to help you format information stored in the cells of a worksheet. There are several convenient ways to format cell information, but this article will cover the Formatting Toolbar.
Excel provides a formatting toolbar, which can be made to appear in the document window. The formatting toolbar provides quick access to the most common formatting commands.
To enable the Formatting Toolbar, choose View > Toolbars and select the Formatting Toolbar. The Formatting Toolbar allows you to adjust the font and font size, text attributes, and text alignment. The Formatting Toolbar also contains a one-click button that will allow you to merge several selected cells together and center text inside them.
The Formatting Toolbar also contains a Currency Style button that allows you to quickly format currency figures. To configure the Currency Style properties, right click on the currency style button and set the properties according to your preference. Each time you use the Currency Style button, these properties will be applied. Other quick formatting buttons include the Percent Style and Comma Style buttons, which control how percentages and commas are used on cell data.
The Formatting Toolbar also contains buttons that allow you to increase or decrease the precision of a real number, by shifting the decimal point to the left or right. You can also increase or decrease text indentations, control the application of grid lines, and change the color of the cell background and the text color within a cell.
Excel 2007 has created a "ghosted" quick access palette that has now made this unnecessary so this will not be relevant to Office 2007 users, well done Microsoft!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment