The contents of a highlighted cell can be formatted in many ways. Font and cell attributes can be added from shortcut buttons on the formatting bar. If this toolbar is not already visible on the screen, select View|Toolbars|Formatting from the menu bar.
For a complete list of formatting options, right-click on the highlighted cells and choose Format Cells from the shortcut menu or select Format|Cells from the menu bar.
If you enter the date "January 1, 2001" into a cell on the worksheet, Excel will automatically recognize the text as a date and change the format to "1-Jan-01". To change the date format, select the Number tab from the Format Cells window. Select "Date" from the Category box and choose the format for the date from the Type box. If the field is a time, select "Time" from the Category box and select the type in the right box. Date and time combinations are also listed. Press OK when finished.
The use of styles in Excel allow you to quickly format your worksheet, provide consistency, and create a professional look.
Select the Styles drop-down box from the formatting toolbar (it can be added by customizing the toolbar). Excel provides several preset styles:
Create your own styles from the Style Dialog Box.
A handy feature on the standard toolbar for formatting text is the Format Painter. If you have formatted a cell with a certain font style, date format, border, and other formatting options, and you want to format another cell or group of cells the same way, place the cursor within the cell containing the formatting you want to copy. Click the Format Painter button in the standard toolbar (notice that your pointer now has a paintbrush beside it). Highlight
the cells you want to add the same formatting to.To copy the formatting to many groups of cells, double-click the Format Painter button. The format painter remains active until you press the ESC key to turn it off.
Excel has many preset table formatting options. Add these styles by following these steps: