MY CARTCell Formatting in Microsoft Excel 2010: Video
This video shows you how to apply cell formatting in Microsoft Excel 2010.
Formatting Cells in Excel 2010: Overview
Note that in the “Home” tab of the Ribbon, you have the “Font” group, the “Alignment” group, and the “Number” group. These groups contain buttons that allow you to format the appearance of selected cells. To do this, just start by selecting the cells you want to format. Then click the desired button.
Note that some of the buttons have a small drop-down arrow next to them. If you click one of these small drop-down arrows, a menu will appear and allow you to specify more button settings. For instance, if you click the drop-down arrow to the right of the “Fill Color” button, it will display the palette of colors in a drop-down menu that you can use to set a new fill color. Once you change the color, the color strip underneath the paint can will change to reflect the new selection. In the future, all you need to do is click the “Fill Color” button to apply your previous color choice.
Let’s examine the buttons that you will find in each group on the “Home” tab. As with the other groups in the Ribbon, not every possible aspect of formatting is shown in the button groupings. For more advanced formatting of cells, you can click the small dialog box buttons in the lower right corner of either the “Font,” “Alignment” or “Number” button groups to open the “Format Cells” dialog box, where you have all formatting options available. Note that you can also open this dialog box by clicking the “Format” button in the “Cells” group on the “Home” tab in the Ribbon, and then selecting the “Format Cells…” command from the drop-down menu that appears.
In the “Format Cells” dialog box, each button group is displayed as a separate tab. You can click the tabs to switch between the formatting options that are available. We will discuss the options available on each tab in a separate lesson. For now, just note how to open the dialog box. You can close the “Format Cells” dialog box by clicking the “x” in the upper right corner of the dialog box.
Back in the “Home” tab of the Ribbon, you have several common formatting options available. In the “Font” group, you have the “Font,” “Font Size,” “Increase Font Size,” “Decrease Font Size,” “Bold,” “Italic,” “Underline,” “Borders,” “Fill Color,” and “Font Color” buttons available.
In the “Alignment” group, you have the “Top Align,” “Middle Align,” “Bottom Align,” “Orientation,” “Wrap Text,” “Align Text Left,” “Center,” “Align Text Right,” “Decrease Indent,” “Increase Indent,” and “Merge and Center” buttons.
Finally, in the “Number” group, you have the “Number Format,” “Accounting Number Format,” “Percent Style,” “Comma Style,” “Increase Decimal,” and “Decrease Decimal” buttons available.
