/en/excel2007/modifying-columns-rows-and-cells/content/
Once you have entered information into a spreadsheet, you will need to be able to format it. In this lesson, you will learn how to use the bold, italic, and underline commands; modify the font style, size, and color; and apply borders and fill colors.
Download the example to work along with the video.
You can select entire columns and rows, or specific cells. To select the entire column, just left-click the column heading, and the entire column will appear as selected. To select specific cells, just left-click a cell and drag your mouse to select the other cells, then release the mouse button.
As you move over the font list, the Live Preview feature previews the font for you in the spreadsheet.
OR
You can change the line style and color of the border.
OR
You can use the fill color feature to format columns and rows and format a worksheet so it's easier to read.
By default, the numbers appear in the General category, which means there is no special formatting.
In the Number group, you have some other options. For example, you can change the U.S. dollar sign to another currency format, switch numbers to percents, add commas, and change the decimal location.
Use the Budget workbook or any Excel workbook you choose to complete this challenge.
/en/excel2007/creating-simple-formulas/content/
About cookies on this site
Sharing your cookies helps us improve the site, optimize your experience, and understand the extent of our impact. By closing this banner, you agree to the use of cookies on this website (This option applies to users outside the United States and Europe). Learn more about how we use cookies by clicking on Cookie Settings.