Microsoft Excel 2007 - Formatting a Worksheet

Convert Text to ColumnsSometimes you will want to split data in one cell into two or more cells.  You can do this easily by utilizing the Convert Text to Columns Wizard.Highlight the column in which you wish to split the dataClick the Text to Columns button on the Data tabClick Delimited if you have a comma or tab separating the data, or click fixed widths to set the data separation at a specific size. Modify FontsModifying fonts in Excel will allow you to emphasize titles and headings. To modify a font:Select the cell or cells that you would like the font appliedOn the Font group on the Home tab, choose the font type, size, bold, italics, underline, or colorFormat Cells Dialog BoxIn Excel, you can also apply specific formatting to a cell. To apply formatting to a cell or group of cells:Select the cell or cells that will have the formattingClick the Dialog Box arrow on the Alignment group of the Home tabThere are several tabs on this dialog box that allow you to modify properties of the cell or cells. Number:  Allows for the display of different number types and decimal placesAlignment:  Allows for the horizontal and vertical alignment of text, wrap text, shrink text, merge cells and the direction of the text.Font:  Allows for control of font, font style, size, color, and additional featuresBorder:  Border styles and colorsFill:  Cell fill colors and stylesAdd Borders and Colors to CellsBorders and colors can be added to cells manually or through the use of styles.  To add borders manually:Click the Borders drop down menu on the Font group of the Home tabChoose the appropriate borderTo apply colors manually:Click the Fill drop down menu on the Font group of the Home tabChoose the appropriate colorTo apply borders and colors using styles:Click Cell Styles on the Home tabChoose a style or click New Cell StyleChange Column Width and Row HeightTo change the width of a column or the height of a row:Click the Format button on the Cells group of the Home tabManually adjust the height and width by clicking Row Height or Column WidthTo use AutoFit click AutoFit Row Height or AutoFit Column WidthHide or Unhide Rows or ColumnsTo hide or unhide rows or columns:Select the row or column you wish to hide or unhideClick the Format button on the Cells group of the Home tabClick Hide & UnhideMerge CellsTo merge cells select the cells you want to merge and click the Merge & Center button on the Alignmentgroup of the Home tab.  The four choices for merging cells are:Merge & Center: Combines the cells and centers the contents in the new, larger cellMerge Across: Combines the cells across columns without centering dataMerge Cells: Combines the cells in a range without centeringUnmerge Cells: Splits the cell that has been mergedAlign Cell ContentsTo align cell contents, click the cell or cells you want to align and click on the options within the Alignmentgroup on the Home tab.  There are several options for alignment of cell contents:Top Align:  Aligns text to the top of the cellMiddle Align:  Aligns text between the top and bottom of the cellBottom Align:  Aligns text to the bottom of the cellAlign Text Left:  Aligns text to the left of the cellCenter:  Centers the text from left to right in the cellAlign Text Right:  Aligns text to the right of the cellDecrease Indent:  Decreases the indent between the left border and the textIncrease Indent:  Increase the indent between the left border and the textOrientation:  Rotate the text diagonally or vertically