| In this tutorial, you will apply formatting options to cells and prepare the sheet for printing. |
| Formatting cells |
| 1) Open the Table Usage 2007.xlsx Sample. |
  |
| Illustration 1: Table usage sample excel file. Click here to view larger image. |
| 2) Select the titles rows. Use the Horizontal Alignment group to center the titles. |
 |
| Illustration 2: Horizontal center alignement. |
| 3) Select the titles rows. Use the Verical Alignment group to center the titles. |
 |
| Illustration 3: Select the range. |
| 4) Select all cells containing numbers. Right click and select the Format cell menu item. |
 |
| Illustration 4: Blank Pivot table layout. |
| 5) Configure all formatting options and press the Ok button. |
 |
| Illustration 5: Formatting options. |
| 6) Continue formatting the cells until you¡¯re satisfied. |
 |
| Illustration 6: Drag and drop fields. Click here to view larger image. |
| 7) Another way to quickly format a data table is to apply a table format. Select the Format as Table command from the Styles Group . |
 |
| Illustration 7: Formatting as table. |
| 8) A style¡¯s list will be displayed. Pick up the desired layout. |
 |
| Illustration 8: Table Layouts. |
| 9) A dialog box will appears with the table range selected. Press the Ok Button. |
 |
| Illustration 9: Table Range. |
| 10) As you cann see, the new layout is applied. Also, a Data filter appears in each column title botton corner. |
 |
| Illustration 10: Automatic format. Click here to view larger image. |
| Formatting cells |
| 11) You could set up specials conditions for automatic format. Select a cell and then, select the Conditional Formatting command from the Styles Group. |
 |
| Illustration 11: Conditional Formatting. |
| 12) Select the Highlight Cells Rules, then Greater than menu item. |
 |
| Illustration 12: Formatting rules. |
| 13) Select the format condition and format style and press the OK button. |
 |
| Illustration 13: A new worksheet. |
| 14) The cell will be formated when the condition is true. |
 |
| Illustration 14: Formatted cell. Click here to view larger image. |
| 15) Select the Top / Bottom Rules, then Top 10 items menu item. |
 |
| Illustration 15: Formatting rules. |
| 16) Select the TOP condition and format style and press the OK button. |
 |
| Illustration 16: Changing the legend format. |
| 17) The cell will be formated when the condition is true. |
 |
| Illustration 17: Changing the cell format. Click here to view larger image. |
| 18) You can copy a formatting condition. Select the cell that contains the desired conditional formation and select the Format Painter command from the clipboard group. |
 |
| Illustration 18: Selecting the cell format. |
| 19) The cursor show a paintbrush. Paint all target cells. These cells will take the pasted format. |
 |
| Illustration 19: Copying Format. |
 |
| Illustration 20: Format applied. |
| Formatting Sheets for printing |
| 20) To see a Print Preview, click on the Office button. Then select Print and click in the Preview Button. |
 |
| Illustration 21: Format applied. |
| 21) To see a Print Preview, click on the Office button. Then select Print and click in the Preview Button. |
 |
| Illustration 22: Preview window. Click here to view larger image. |
| 22) Select the Page Setup command from the Print Group. |
 |
| Illustration 23: Page setup. |
| 23) Configure Page Margins. Select the Center Page options to center the printable area in the sheet. |
 |
| Illustration 24: Margins setup. |
| 24) Configure Header / Footer. Select the Custom Header button to open the header window. Write the headers. Select font and built-in formulas to show date and time, page numbers, etc. |
 |
| Illustration 25: Header setup. Click here to view larger image. |
| 25) Configure Header / Footer. Select the Custom Footer button to open the footer window. Write the footers. Select font and built-in formulas to show file path, sheet name, etc. |
 |
| Illustration 25: Footer setup. Click here to view larger image. |
| 26) See the results at preview window. |
discuss this topic to forum
