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.
Format Cells Dialog Box
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.
Dates and Times
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:
Style Dialog Box
Create your own styles from the Style Dialog Box.
Create a New Style
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
Excel has many preset table formatting options. Add these styles by following these steps: