Formatting Excel Sheets

                                                                                

                                                                                           Bridegroom Killed During Wedding

Formatting Worksheets in Excel 2010

To further enhance your spreadsheet you can format a number of elements such as text, numbers, coloring, and table styles.  Spreadsheets can become professional documents used for company meetings or can even be published.

Wrap Text

You can display multiple lines of text inside a cell by wrapping the text. Wrapping text in a cell does not affect other cells.

1.  Click the cell in which you want to wrap the text.

2.  On the Home tab, in the Alignment group, click Wrap Text.

3.  The text in your cell will be wrapped.

NOTE: If the text is a long word, the characters won't wrap (the word won't be split); instead, you can widen the column or decrease the font size to see all the text. If all the text is not visible after you wrap the text, you might have to adjust the height of the row. On the Home tab, in the Cells group, click Format, and then under Cell Size click AutoFit Row.

Format Numbers

In Excel, the format of a cell is separate from the data that is stored in the cell. This display difference can have a significant effect when the data is numeric.  For example, numbers in cells will default as rounded numbers, date and time may not appear as anticipated.  After you type numbers in a cell, you can change the format in which they are displayed to ensure the numbers in your spreadsheet are displayed as you intended.

   

1.  Click the cell(s) that contains the numbers that you want to format.

2.  On the Home tab, in the Number group, click the arrow next to the Number Format box,

      and then click the format that you want.

If you are unable to format numbers in the detail you would like that you can click on the More Number Formats at the bottom of the Number Format drop down list. 

1. In the Category list, click the format that you want to use, and then adjust settings to the right of the Format Cells dialog box.  For example, if you’re using the Currency format, you can select a different currency symbol, show more or fewer decimal places, or change the way negative numbers are displayed.

Cell Borders

By using predefined border styles, you can quickly add a border around cells or ranges of cells. If predefined cell borders do not meet your needs, you can create a custom border.

NOTE: Cell borders that you apply appear on printed pages. If you do not use cell borders but want worksheet gridline borders for all cells to be visible on printed pages, you can display the gridlines.

Online Marketing Tips Free!!!

Apply Cell Borders

1.   On a worksheet, select the cell or range of cells that you want to add a border to, change the border  
      style on, or remove a border from.

2.  Go to the Home tab, in the Font group

3.   Click the arrow next to Borders

4.  Click on the border style you would like

5.  The border will be applied to the cell or cell range

NOTE: To apply a custom border style, click More Borders. In the Format Cells dialog box, on the Border tab, under Line and Color, click the line style and color that you want.

Remove Cell Borders

1.  Go to the Home tab, in the Font group

2.   Click the arrow next to Borders

3.  Click No Border .

NOTES: The Borders button displays the most recently used border style. You can click the Borders button (not the arrow) to apply that style.

Cell Styles

You can create a cell style that includes a custom border, colors and accounting formatting.

1.  On the Home tab, in the Styles group, click Cell Styles.

2.  Select the different cell style option you would like applied to your spreadsheet.

NOTE: If you would like to apply a cell fill and a cell border, select the cell fill color first the ensure both formats are applied.

Cell and Text Coloring

You can also modify a variety of cell and text colors manually. Cell Fill

1.  Select the cells that you want to apply or remove a fill color from.

2.  Go to the Home tab, in the Font group and select one of the following options:

a.  To fill cells with a solid color, click the arrow next to Fill Color , and then under Theme Colors or    

     Standard Colors, click the color that you want.

b.  To fill cells with a custom color, click the arrow next to Fill Color , click More Colors, and then in the 

     Colors dialog box select the color that you want.

c.  To apply the most recently selected color, click Fill Color.

.

NOTE: Microsoft Excel saves your 10 most recently selected custom colors. To quickly apply one of these colors, click the arrow next to Fill Color, and then click the color that you want under Recent Colors.

Remove Cell Fill

1.  Select the cells that contain a fill color or fill pattern.

2.  On the Home tab, in the Font group, click the arrow next to Fill Color, and then click No Fill.

Text Color

1. Select the cell, range of cells, text, or characters that you want to format with a different text color.

2.  On the Home tab, in the Font group and select one of the following options:

a.  To apply the most recently selected text color, click Font Color .

b.  To change the text color, click the arrow next to Font Color , and then under Theme Colors

     or Standard Colors, click the color that you want to use.

Bold, Underline and Italics Text

1.  Select the cell, range of cells, or text.

2.  Go to the Home tab, in the Font group

3.  Click on the Bold (B) Italics (I) or Underline (U) commands.

4.  The selected command will be applied.

Customize Worksheet Tab

1.  On the Sheet tab bar, right-click the sheet tab that you want to customize

2.  Click Rename to rename the sheet or Tab Color to select a tab color.

3.  Type in the name or select a color you would like for your spreadsheet.

4.  The information will be added to the tab at the bottom of the spreadsheet.