Format Worksheet
Convert Text to Columns
Sometimes you will want to split data in one cell into two or more cells. You cando this easily by utilizing the Convert Text to Columns Wizard.
§ Highlight the column in which you wish to split the data
§ Click the Text to Columns button on the Data tab
§ Click 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 Fonts
Modifying fonts in Excel will allow you to emphasize titles andheadings. To modify a font:
§ Select the cell or cells that you would like the font applied
§ On the Font group on the Home tab, choose the font type, size, bold, italics, underline, or color
Format Cells Dialog Box
In Excel, you canalso 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 formatting
§ Click the Dialog Box arrow on the Alignment group of the Home tab
There 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 anddecimal places Alignment: Allows for the horizontal and vertical alignment of text, wrap text, shrink text, merge cells and the direction ofthe text.
Font: Allows for control of font, font style, size, color, and additional features
Border: Border styles and colors
Fill: Cell fill colors and styles
Add Borders and Colors to Cells
Borders and colors can be added to cells manually or through the use of styles. To addborders manually:
§ Click the Borders drop down menu on the Font group of the Home tab
§ Choose the appropriate border
§ Click the Fill drop down menu on the Font group of the Home tab
§ Choose the appropriate color
§ Click Cell Styles on the Home tab
§ Choose a style or click New Cell Style
Post a Comment