::Online Microsoft Office,Web ,Graphic and many more Tutorials
Format Cells Dialog Box :
The formatting characteristic of a cell or range includes the numeric display format, the alignment, font, border, patterns, and cell protection. A cell or range in a worksheet can be formatted by Click Cell command from the Format menu. Number tab -
The data type can be selected from the options on this tab. Select General if the cell contains text and number, or another numerical category if the cell is a number that will be included in functions or formulas. Shortcut Keys for formatting Numbers:
Ctrl+Shift+$ For currency with two decimal places
Ctrl+Shift+! For numeric with two decimal places
Ctrl+Shift+% For percentage with no decimal places
Ctrl+Shift+^ For scientific notation
Ctrl+Shift+~ For the general format
Ctrl+Shift+@ For the hh:mm time format
Ctrl+Shift+# For the d-mmm-yy date format
Alignment tab -
These options allow you to change the position and alignment of the data with the cell. Font tab - All of the font attributes are displayed in this tab including font face, size, style, and effects. Border and Pattern tabs -
These tabs allow you to add borders, shading, and background colors to a cell. Dates and Times -
If you enter the date "January 1, 2008" into a cell on the worksheet, Excel will automatically recognize the text as a date and change the format to "1-Jan-08". 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
Style :
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 Comma - Adds commas to the number and two digits beyond a decimal point. Comma [0] - Comma style that rounds to a whole number. Currency - Formats the number as currency with a dollar sign, commas, and two digits beyond the decimal point. Currency [0] - Currency style that rounds to a whole number. Normal - Reverts any changes to general number format. Percent - Changes the number to a percent and adds a percent sign. : Create New styles or modify style
- Go to Format menu and click on style
- Modify the attributes by clicking the Modify button.
- Click the Style box on the Formatting toolbar so the style name is highlighted.
- Delete the text in the Style box and type the name of the new style.
- Check the items under Style includes that the style should format.
- Click Add to preview the formatting changes on the worksheet.
- Highlight the style you want to apply to the paragraph and click OK.
Auto Format :
Excel has many preset table formatting options. With these preset formats, you can select all of the characteristics or only some .
- Highlight the cells that will be formatted
- Go to the Format menu and Click AutoFormat...The AutoFormat dialog box appears.
- Select the desired AutoFormatting style
- OPTIONAL: To apply only some of the characteristics of a particular AutoFormat,
- Click Optional button
- Under Formats to apply, select/deselect the desired options
- Click Ok
