Thursday, December 13, 2012

Format


Format: Includes to change or set the font, font size, style, alignment to change or set the paragraph alignment, indents & spacing to add bullet & numbering border & shading, to set the color for the text before background, to set tabs or drop tabs & change the cases.


Cell: In this option to change the fonts, font styles (Regular, Italic, Bold, Bold italic), point size (1 to 1638), font colour, underline & underline colour, effects means strikethrough, superscript, subscript, hidden, small caps, all caps, outline, shadow, engrave, embosses etc. & you also set the character animation of sees types ( blinking background, lass Vegas, marching black ants, marching red ants, sparkle text).
Cells – Format the way a number is displayed; alignment of data in the cell(s), font (size, color, style, etc.), borders and colors for the selected cells, and you may also lock the contents of a cell here.

Row: Specify a row height, choose auto-fit, and hide or unhide the selected row.

Column: Specify a column width, choose auto-fit, hide or unhide the selected column, or choose the standard width for a column.

Sheet: Here you can rename the sheet if sheet 1 is not descriptive enough (and it's not), you can hide or unhide a sheet, or you can tile an image in the background of the entire sheet.

Auto Format: There are sixteen predestined formats to change the look of your spreadsheet. You may apply the format to the entire sheet or only to selected cells.
Worksheet: It is used to formatting the worksheet.
Auto format: It is used to select the style of the data.
Conditional format: It is used to

Conditional Formatting: Applies formats to selected cells that meet specific criteria based on values or formulas you specify. Maximum Three conditions can be set in the range.

Styles: Styles are named groups of formatting command. Used to present your document with consistent formatting. When you apply a style, each format in the style is applied simultaneously to selected text.