How to make a table in excel with lines

Updated: 01/24/2018 by Computer Hope

Adding a table to your Excel spreadsheet is a quick and easy way to organize and sort data. Below are the steps to insert a table in Microsoft Excel.

Adding a table

1. Open Excel and move to the cell where you want to insert the table.
2. Click the Insert tab.
3. Click the Table button.

Resizing the table

Once the table is inserted, adjust the table's size by moving the mouse to the bottom right corner of the table until you get a double-headed arrow.

Once this arrow is visible, click-and-drag the table in the direction you want the table to expand. Drag the cursor to the right to add more columns or down to add more rows.

Changing the look of the table

After the table is added, move your cursor to a cell in the table and click the Design tab.

In the Design tab, adjust the Header Row, Total Row, and how the rows appear. Also adjust the overall look of the table by clicking one of the table styles.

Using your table

Once you get the table looking the way you want it to appear

how to create table in ms excel 2010

how to put table in ms excel