As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Make a Table in Excel: Step-by-Step Guide

Excel is a powerful spreadsheet application that allows you to organize, manipulate, and analyze data. Tables are a great way to visualize and organize data in Excel, and they can be created in a few easy steps.

Create a Table

To create a table in Excel, you can use either the Insert Table command or the Draw Table command.

Insert Table:

  1. Select the data range that you want to include in the table.
  2. Click the Insert tab on the ribbon.
  3. In the Tables group, click the Table command.

Excel will automatically create a table that is the size of your data range.

Draw Table:

  1. Select the data range that you want to include in the table.
  2. Click the Insert tab on the ribbon.
  3. In the Tables group, click the Table command.
  4. A dialog box will appear. Select the Draw Table option, and then click OK.

To create the table, click the mouse in the first cell of the data range, and then drag the mouse to the last cell of the data range. When you release the mouse, the table will be created.

Modify a Table

Once a table has been created, you can modify it in a number of ways.

  • Design Tab:
  • The Design tab contains options for modifying the look of the table. For example, you can add or remove banded rows or columns, or apply a predefined table style.
  • Layout Tab:
  • The Layout tab contains options for adding or removing headers, footers, or totals rows.
  • Format Tab:
  • The Format tab contains options for formatting the cells in the table.

Add Data to a Table

Once a table has been created, you can add data to it.

  1. Click anywhere inside the table to activate the Table Tools tabs on the ribbon.
  2. Click the Insert tab.
  3. In the Rows & Columns group, click the Insert Right or Insert Below command.

Delete Data from a Table

To delete data from a table:

  1. Click anywhere inside the table to activate the Table Tools tabs on the ribbon.
  2. Click the Data tab.
  3. In the Sort & Filter group, click the Clear command.

Excel will delete all data from the selected cells.

Sort Data in a Table

  1. Click anywhere inside the table to activate the Table Tools tabs on the ribbon.
  2. Click the Data tab.
  3. In the Sort & Filter group, click the Sort command.
  4. In the dialog box, select the column to sort by, and then click OK.

Filter Data in a Table

  1. Click anywhere inside the table to activate the Table Tools tabs on the ribbon.
  2. Click the Data tab.
  3. In the Sort & Filter group, click the Filter command.
  4. A drop-down arrow will appear in the header cell of each column. Click the arrow to select desired filter criteria.

Print a Table

  1. Click anywhere inside the table to activate the Table Tools tabs on the ribbon.
  2. Click the Layout tab.
  3. In the Page Setup group, click the Print Area command.
  4. In the dialog box, select the Table option, and then click OK.

To print the table, click the File tab, and then click Print. Select the desired printer and printing options, and then click Print. Excel will print the selected table.