Jan's Illustrated Computer Literacy 101 Logo:Jegsworks Jan's Illustrated Computer Literacy 101


Home > Jan's CompLit 101 > Working with Words > Report > Finish > Add Table
Icon: Arrow - Previous pagePrevious    NextIcon: Arrow - Next page

Jan's Working with Words

    Report: Finish: Add Table

Report page with table You can now add to the report a table about the sales of the Special Anniversary trips. This kind of information is much easier to understand in a table. All the numbers just blur together when you read them in a paragraph.

You will use a simple formula in your table. When your calculations get much beyond simple addition, you should consider including a spreadsheet in your report, possibly on a separate page, instead. Spreadsheets programs, after all, are written to make complicated calculations easy.


Icon Step-by-Step 

Step-by-Step: Add Table

 Icon Step-by-Step

What you will learn: to draw a table in an existing document
to apply Table style
to center table and wrap text
to use AutoSum and view formula
to right align numbers

Start with: Icon: Class storage device Icon- Word with blank document, report-WorldTravelInc4-Lastname-Firstname.docx

Draw Table

The current document has a sentence that refers to "The table below..." but there is no table there yet. With the current template and editing that you have done, there is not room on the page for a table. That's an easy fix!

  1. Icon: Class storage device Save as  report-WorldTravelInc5-Lastname-Firstname.docx on your Class disk in the word project4 folder.
  2. If necessary, open your last version of the report, report-WordTravelInc4-Firswtname-Lastname.docx
  3. Place the cursor at the left end of the line: Summary of results and insert a Page Break.
  4. Drawing a table. Dotted lines on ruler show pencil position. (Word 2013)Place cursor on blank line after the sentence The table below summarizes... 
    The original template had a table in this spot that we deleted.
  5. Draw a table here that is about 3.5" wide and 2" high.

    Initial table with text wrapping around the tableThe existing text will wrap around the new table.

    Icon: Trouble Problem: Table includes text from next paragraph.
    You dragged from a spot a bit too low.
    Solution: Delete the table containing text and try again. This time drag from a bit above the paragraph mark.

  6. Table with 4 columns and 6 rows, text wrapping at right (Word 2013)Draw lines to create 6 rows and 4 columns.
    The rows cannot be shorter than the default row height but some may be taller. The exact widths and heights are not important for now.

    If your table was too short, it will enlarge automatically as you add rows.

  7. Press the ESC key to stop drawing.
  8. Text to enter into table cellsEnter text as shown in the illustration at right.
    You must type in the commas yourself.

    In Excel you can apply a number style to text to automatically handle commas, but not in Word. 

  9. Text entered into table (Word 2013)Resize the table by dragging the borders, if necessary, to make the column headings fit on one line and also "New Zealand" should fit onto one line.
    Table width should be about 3.5" and the total table height should be about 2".

    Look at your rulers but don't worry if the sizes are not exact or if the texts wraps differently alongside the table.

  10. Icon: Class storage device Save.
    [
    report-WorldTravelInc5-Lastname-Firstname.docx]

Apply Table Style

A table style has many advantages over manually formatting a table. It will automatically reapply when you rearrange, add, or delete rows or columns. You can apply a table style early but manual formatting needs to wait until after you are SURE that the table structure is finished.

  1. Icon: Experiment Experiment: Table Styles
    • On the Table Tools: Design tab, hover over one of the styles in the gallery of Table Styles. Live Preview shows what the table would look like.
    • What changes did the style make? Look for changes in borders and fonts and shadings.
    • Hover over several different styles from different rows in the gallery.
    • Change the choices in the Table Style Options tab group and hover over your choices again.
    • What difference do you see?
      (Scroll the rows in the gallery on the ribbon instead of using the More button. The expanded gallery is so large that it will hide your table.)

      When you are ready to continue...

  2. Ribbon: Table Tools: Design - Table Style Options tab group (Word 2010)With the cursor in the table anywhere, on the tab Table Tools: Design in the Table Styles Options tab group, check only the boxes  listed below and leave the others unchecked:
    • Header row
    • First column 
    • Total row
  3. Click on the More button to expand the gallery of Table Styles or scroll the rows in the ribbon gallery. Do you see different styles? You should if you had to check or uncheck option boxes.
  4. Select a style Table Style: Medium shading - Accent 5 (Word 2010):
    This style uses Aqua-Accent 5 for shading the first row. It has aqua colored horizontal borders for the rows and a double line border above the Total row. The text in the first column and the first row will be bold, but you cannot see that in the thumbnail.

    Table Styles gallery expanded - Medium shading, Accent 1 (Word 2010)Icon: Word 2007 Icon: Word 2010 Word 2007, 2010:
    Medium Shading 1-Accent 5.

    Table Styles gallery expanded - Medium shading, Accent 1 (Word 2010)Icon: Word 2013 Icon: Word 2016 Word 2013, 2016:
    List Table 4 - Accent 5

  5. Table style applied to the table (Word 2013)Icon: Class storage device Save.
    [report-WorldTravelInc5-Lastname-Firstname.docx]


Format Table

Next you will center the table on the page and keep the text from wrapping around it.

  1. Table centered on the page with text wrapping around both sides. (Word 2013)Select the whole table.
  2. On the Home tab or Icon: Word 2010 Mini-Toolbar, click the Center button.
    The whole table is centered on the page in the middle of the text. Not quite what we want!
  3. Right Click Menu: Table Properties (Word 2010)Right click on the table and click on the command Table Properties.
    The Table Properties dialog opens.
     
  4. Dialog: Table Properties - Table tab (Word 2013)If necessary, click on the tab Table.
    The Alignment is already set to Center because of your previous action. You could have waited and selected Center for the table here instead of using the Center button.
  5. In the Text wrapping section, click on None and then on OK.
  6. If necessary, adjust column widths so that New Zealand is on one line in its cell and # of people and Total Sales are on two lines in their cells.

  7. Table centered on page with no text wrapping. (Word 2013)Icon: Class storage device Save.
    [report-WorldTravelInc5-Lastname-Firstname.docx]

TipIf you apply formatting manually and then apply an Table Style, you may replace some or all of your manual formatting with that of the style. It depends on what features the style includes. The order you do things can make a big difference!
 


AutoSum and View Formula

You could have typed in totals in the bottom row when you entered the text. But then, if you had to change a number, the total would NOT automatically update to use the new number. Using a formula to calculate the total can prevent this embarrassing error.

  1. Place the cursor in the second cell of the bottom row, which is in the column '# of people'. Dialog: Formula =sum(above) (Word 2010)
  2. On the tab Table Tools: Layout in the Data tab group, click the button Formula Button: Formula (Word 2007) Button: Formula (Word 2010).
    The Formula dialog opens already filled in with the formula to add up the cells above the current cell, =SUM(ABOVE) since that is the formula used the most.
  3. Dialog: Formula - Paste function list (Word 2013)Click the arrow for the Paste function text box and inspect the list of functions.
    We will not be exploring other functions for Word tables in these lessons. We could have used the function =PRODUCT(B2,C2) to calculate the Total Sales column for row 2. A spreadsheet program handles calculations better than Word does.
  4. Formula calculates the total number of people and display the total in the cell (Word 2013)Click on OK.
    Word adds up the cells above the current cell and shows the total in the cell, not the formula.
  5. Repeat for the last cell on the last row.
     
  6. Two totals showing in the table (Word 2013)Click in the new total.
    The background turns gray, which shows that this value is a field.

    The Word Options dialog controls whether or not a field shows a highlight.
    Options > Advanced > Show document content > Field
    Choices are Never, Always, and When selected.   

  7. Right Click Menu: Toggle Field Codes (Word 2013) Right click on each field and choose  Toggle field codes  to show the formula being used.

    Field codes showing for the totals cells (Word 2013)Notice that the row height increases to show the formula.

  8. Right click again on each field and choose  Toggle field codes  to make both fields show the sum again instead of the formula.
    The row returns to the previous height.
  9.  Icon: Class storage device Save.
    [report-WorldTravelInc5-Lastname-Firstname.docx]


Alignments

Numbers usually look better and are easier to read when either aligned to the right or justified on a decimal tab. 

  1. Select the cells containing numbers (Word 2013) Drag from the second cell in the second row, which has the number 50 in it, down to the bottom right cell. This selects all the cells with numbers.
  2. Ribbon: Table Tools: Layout - Align Center Right (Word 2013)On the tab Table Tools: Layout in the Alignment tab group, click on the button Align Center Right.
    The numbers move to the right. The vertical alignment in the cells does not change. There is not any extra height to rearrange in.

    Table with numbers aligned to the right (Word 2013)

  3. Icon: Class storage device Save.
    [report-WorldTravelInc5-Lastname-Firstname.docx]

Your table is now complete!

Report pages after adding a table