Skip to content
Tutorials Center
My learning

Topics

Lesson 17 of 40 ยท Text, Shapes and SmartArt

Tables in PowerPoint: Insert, Format, Merge and Paste from Excel

Create and format PowerPoint tables: insert, resize, merge and split cells, apply styles, align text, paste from Excel or Word and keep tables readable.

A table is the right tool when information has two dimensions: items down the side, attributes across the top. Comparing three plans by price, speed and support is a table, not a bullet list. PowerPoint tables are simpler than Excel's but cover everything a slide needs.

Inserting a table

  1. Insert > Table. Drag across the grid to choose columns and rows (up to 10 by 8), or choose Insert Table and type the numbers.
  2. Draw Table lets you sketch cells with a pencil, useful for irregular layouts.
  3. Excel Spreadsheet embeds a mini workbook (use sparingly; it is heavy).
  4. Click the table icon inside a content placeholder.

Move between cells with Tab and Shift+Tab. Pressing Tab in the last cell adds a new row.

Selecting and sizing

  • Click a cell border area, or drag across cells. Point at the left edge of a row or above a column (the cursor turns into an arrow) to select the entire row or column.
  • Ctrl+A inside a cell selects all cells.
  • Drag the table border to resize everything proportionally with Shift, or drag column and row borders individually.
  • Table Layout > Cell Size: type exact height and width, Distribute Rows and Distribute Columns to equalize.
  • Table Layout > Insert Above / Below / Left / Right and Delete change the structure.

Table styles and options

Click in the table and open Table Design:

Option Effect
Header Row Special formatting for the first row (and it is read as headers by screen readers)
Total Row Special last row
Banded Rows / Columns Alternating shading
First / Last Column Emphasized side columns
Table Styles Gallery of themed formats; hover to preview
Shading, Borders, Effects Per-cell control
Pen Style, Weight, Color Used with Draw Borders

Most good tables use a header row, banded rows off or very subtle, thin horizontal lines and lots of cell padding. Heavy grids and bright banding look cluttered.

A table people can read

Header row Clear, short labels
Align numbers Right or on the decimal
Cell padding Room to breathe
Few columns Five at most

If it needs a magnifier, move the data to a handout.

1 / 2

Merge, split and align

  • Merge Cells: select adjacent cells, Table Layout > Merge Cells (or right-click). Use for a spanning header.
  • Split Cells: choose the number of columns and rows to cut a cell into.
  • Alignment group: Align Left, Center, Right and Top, Middle, Bottom. Numbers read best right-aligned (or aligned on the decimal point), text left-aligned, and vertical middle for tidy rows.
  • Cell Margins: padding inside cells (Narrow, Normal, Wide, Custom).
  • Text Direction: rotate column headers 270 degrees for narrow columns.

Avoid merged cells in data tables: they confuse screen readers and break sorting if you later copy to Excel. Use them only for visual headers.

Bringing data in

  • From Excel: select the range in Excel, Ctrl+C, and in PowerPoint right-click and choose a paste option: Use Destination Styles (PowerPoint table, themed), Keep Source Formatting, Embed (an Excel object) or Picture. For a lasting connection to numbers use Link & Keep Source Formatting, but then the file must be reachable on the presenting computer.
  • From Word: a Word table pastes as a normal table.
  • Typed or CSV text: paste into a cell, or use Insert > Table then paste tab-separated values.

Charts are better than tables when the point is a trend or comparison between many values (see charts).

Cell-by-cell design tricks

  • Highlight the key cell with a bold color and leave the others neutral so the eye lands on it.
  • Remove vertical lines, keep thin horizontal rules.
  • Put units in the header ("Revenue, $ M"), not in every cell.
  • Use Table Design > Borders > No Border and add one line under the header for a clean "report" look.

Try it: render a table as text and check its width (stand-in)

PowerPoint does not tell you when a table is too dense. This stand-in prints a small table with aligned numbers and reports the column and cell counts, with a warning over a density limit. It is a model of a rule and not PowerPoint.

JS Table density check (stand-in)

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Common mistakes

  • Using a table only to line up text or images. Use align and distribute.
  • Tiny fonts: tables must follow the 24 pt rule as much as text does; set Home > Font for the whole table.
  • No header row, which hurts accessibility.
  • Pasting a huge Excel range as a table. Trim it first or summarize.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. Which key moves to the next cell in a PowerPoint table?

    Tab moves right; in the last cell it adds a new row. Enter starts a new line inside the cell.
  2. 2. Which option marks the first row as column headings?

    Header Row formats the first row and exposes it as headers to assistive technology.
  3. 3. How should you usually align numbers in a column?

    Right alignment lines up digits so values compare easily.
  4. 4. What does pasting with 'Use Destination Styles' do?

    Destination styles convert the Excel range to a native, themed table.

Summary

  • Use tables for two-dimensional comparisons; Tab moves between cells.
  • Table Design offers header row, styles and shading; keep styling light.
  • Merge cells sparingly; align numbers right, text left.
  • Paste from Excel with destination styles; trim to what the audience needs.

Next: Pictures and Icons