Format Worksheet
Convert Text to Columns
Sometimes
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 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
and
headings. 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 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 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
and
decimal places Alignment: 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 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
add
borders 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
.jpg)
0 comments:
Post a Comment
Enter your comments to JoxTech