How to Make a Table in Excel with Lines (with Easy Steps)

If you are searching for the solution or some special tricks to make a table in Excel with lines then you have landed in the right place. There are some quick steps to make a table in Excel with lines. This article will show you each and every step with proper illustrations so you can easily apply them for your purpose. Letโ€™s get into the central part of the article.


Download Practice Workbook

You can download the practice workbook from here:


What Is an Excel Table?

In the later versions of Excel 2004, the Table feature is available to convert a simple dataset to a formatted table. An Excel table allows the user to do many things like sorting, filtering, showing totals, etc easily which is not possible directly in a simple dataset.

Benefits of Excel Table:

  • Sorting Data: You can easily sort data by clicking on the drop-down arrow in the column header.
  • Filtering Data: You can also filter data as your wish from the options that are opened by clicking the drop-down arrow in the header.
  • Inserting: You can easily insert a new row or column into the table and the table will expand or shrink its range automatically.
  • Styles: You can select any of the built-in styles to format the table or you can create custom styles for the table.
  • Autofill: When you apply any formula or format to any cell of a column in the table then it will be auto-filled in other cells of the column.
  • Table Name: When you have multiple datasets then you can refer to any cell with the name of the table and column header.
  • Total of Rows: You can also show the subtotal of the rows in a column without using any formula.

Steps to Make a Table in Excel with Lines

In this section, I will show you how to make a table in Excel with lines on Windows operating system. You will find detailed explanations of methods and formulas here. I have used Microsoft 365 version here. But you can use any other versions as of your availability. If face any issues in your version then leave us a comment.

๐Ÿ“Œ Step 1: Prepare Dataset

First, you have to prepare the dataset before creating a table. For this, create a header row then insert the values accordingly.

How to Make a Table in Excel with Lines

Read More: How to Create a Table with Existing Data in Excel


๐Ÿ“Œ Step 2: Format the Dataset as a Table

After inserting the data into a worksheet, select any cells of the dataset. Then, go to the home tab and click on the โ€œFormat as Tableโ€ option in the โ€œStylesโ€ menu.

Format the Dataset

Read More: How to Create Table from Data Model in Excel (With Easy Steps)


๐Ÿ“Œ Step 3: Apply a Table Style

When you click on the โ€œFormat as Tableโ€ option then a list of table styles will appear. Select any of the styles from the options and apply on the dataset.

How to Make a Table in Excel with Lines

Read More: Create Table in Excel Using Shortcut (8 Methods)


๐Ÿ“Œ Step 4: Select Data Range for Table

After selecting the Table Style a pop-up window will appear which will show the range of the dataset to make a table. Recheck the data range whether it is correct or not. As you have selected a cell on the dataset so, Excel will select all the cells adjacent to the selected one automatically.

  • Tick that the checkbox says โ€œMy table has headersโ€ if not ticked.
  • Then, press OK.

Select Data Range

As a result, you will see the dataset converted to an Excel table. And, you will find there is a drop-down arrow in each cell of the header row. But you should notice that there is noย borderline in the table.

Select Data Range for Table

Read More: Excel VBA to Create Table from Range (6 Examples)


๐Ÿ“Œ Step 5: Create Border Lines in the Table

Excel table styles contain different colors for rows to differ them from each other but there is no borderline in them. So, when you will move to print you will see no separation line between the rows and columns. For this, you have to imply the border line manually. Follow the steps below to do this:

  • Select all the cells of the table first.

Create Border Lines in the Table

  • Then, go to the Home tab and click on the Border icon in the Font menu.
  • A list of borders will appear and select the โ€œAll Bordersโ€ option.

Create Border Lines in the Table

As a result, you will see that the table rows and columns are separated by lines. Now, if you want to print then you will see lines between the rows and columns.

How to Make a Table in Excel with Lines

In addition, you can apply a name to the table for identification, For this:

  • Select any cell of the table and go to the Table Design tab in the top ribbon.
  • Then, in the Properties menu, you will find a box to insert a table name. Write an appropriate name in the box.
  • So, you can refer or call this table by this name.

Create Border Lines in the Table

Read More: Create a Table in Excel Based on Cell Value (4 Easy Methods)


Conclusion

In this article, you have found how to make a table in Excel with lines. I hope you found this article helpful. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Osman Goni Ridwan

Osman Goni Ridwan

I am Ridwan, graduated from Naval Architecture and Marine Engineering Dept, BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands. My prime goal is to be a data analyst as I do love to solve problems and play with data.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo