Excel Guides

How to Spread Out a Table in Excel

Assuming you have a table in Excel and you want to spread out the columns:

  1. Select the entire table.
  2. On the Layout tab, in the Table group, click View Gridlines. This displays gridlines around all the cells in the table, making it easier to see where the table boundaries are.
  3. On the Layout tab, in the Cells group, click Merge & Center. This removes any merged cells in the selection.
  4. On the Home tab, in the Alignment group, click the   Decrease Indent

    This decreases any existing indent on your selection.

  5. Click anywhere in your table.

  6. On the "Layout" (or "Table Tools Layout", if you're using Excel 2007) tab of the Ribbon, click "Distribute Columns Evenly."

  7. >

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.