Excel Tutorial: How To Make Table In Excel Sheet


Creating tables in an Excel sheet is a crucial skill for anyone working with data. Tables not only help in presenting data in an organized manner but also offer several benefits for data analysis and manipulation.

Importance of Creating a Table in an Excel Sheet

  • Easy Data Management: Tables make it easier to manage and manipulate data in Excel, allowing users to quickly sort, filter, and analyze the information.
  • Improved Readability: Tables enhance the visual appeal of the data and make it easier for users to understand the information at a glance.

Benefits of Using Tables for Organizing and Analyzing Data

  • Structured Layout: Tables provide a structured layout for data, making it easier to identify and work with specific data points.
  • Automatic Formatting: Excel tables come with built-in formatting options that automatically expand to accommodate new data and apply formatting to new rows or columns.

Key Takeaways

  • Creating tables in Excel is essential for efficient data management and analysis.
  • Tables make it easier to manage and manipulate data, improving readability and overall organization.
  • Excel tables provide automatic formatting and a structured layout for organized data analysis.
  • Users can use table features such as sorting, filtering, and the total row for quick calculations.
  • Customizing tables by adding or removing columns and formatting improves the visual appeal and usability of the data.

Understanding the Excel interface

When starting with Excel, it's important to understand the basic interface in order to effectively create and manage tables. Here's a breakdown of how to navigate through the Excel interface.

A. Explain how to open Excel and create a new sheet

Firstly, open Microsoft Excel by clicking on the Excel icon or searching for it in the start menu. Once Excel is open, you can create a new sheet by going to the File tab and selecting New. This will open a new blank sheet where you can start creating your table.

B. Familiarize users with the menu options and ribbon tabs for easy navigation

Excel has various menu options and ribbon tabs that provide easy access to different functions and tools. The Home tab contains commonly used tools such as font formatting, alignment, and cell editing. The Insert tab allows users to insert tables, charts, and other elements into the sheet. The Page Layout tab provides options for adjusting the layout and printing settings. The Formulas tab contains functions and formulas for calculations. The Data tab is used for sorting, filtering, and managing data. The Review tab is for proofing, comments, and changes. Lastly, the View tab allows users to change the view of the sheet, such as zoom and layout options.

Formatting your data

When creating a table in an Excel sheet, it's important to ensure that your data is properly formatted to make the table clean and organized. This helps in easy data analysis and interpretation.

A. Show how to select the data range for the table

Before creating a table, you need to select the data range that you want to include in the table. This can be done by clicking and dragging your mouse to select the cells containing the data. Alternatively, you can click on the first cell, hold down the Shift key, and then click on the last cell to select the entire range.

B. Demonstrate how to remove blank rows from the selected data

Blank rows can clutter your data and affect the table's appearance. To remove blank rows from the selected data, you can use the "Go To Special" feature. First, select the entire data range, then go to the "Home" tab, click on "Find & Select" in the editing group, and choose "Go To Special." In the dialog box that appears, select "Blanks" and then click "OK." This will select all the blank cells in the data range. Right-click on any of the selected cells, choose "Delete," and then select "Entire Row" to remove the blank rows from your selected data range.

Creating the table

When working in Excel, organizing your data with a table is a great way to make it more visually appealing and easy to navigate. Follow these steps to create a table from your selected data:

  • Select the data: Begin by selecting the range of cells that you want to include in your table. This can be done by clicking and dragging your mouse to highlight the desired cells.
  • Go to the Insert tab: Once the data is selected, navigate to the Insert tab in the Excel ribbon at the top of the screen.
  • Click on Table: In the Tables group, click on the Table option. This will prompt a dialog box to appear.
  • Verify the range: Excel will automatically detect the range of cells you have selected. Make sure that this range is accurate, and adjust if necessary.
  • Check the "My table has headers" box: If your data has headers (i.e. column titles), make sure this box is checked. This will allow Excel to use these headers to label the columns in your table.
  • Click OK: Once you've verified the range and header settings, click OK. Your data will now be converted into a table format.

Exploring table styles and formatting options

Now that you have created a table in Excel, you can explore the various styles and formatting options to customize its appearance. Here are some formatting features you can utilize:

  • Table Styles: Excel offers a variety of pre-designed table styles that you can apply to your table. These styles include different combinations of colors, fonts, and border designs to enhance the visual appeal of your table.
  • Header Row: You can choose to freeze the header row so that it remains visible as you scroll through your data. This can be done by checking the "Header Row" option in the Table Design tab that appears when the table is selected.
  • Total Row: If your table contains numerical data, you may want to add a Total Row at the bottom of the table to automatically calculate the sum, average, count, and other functions for the selected column.
  • Table Name: Give your table a descriptive name by typing it into the "Table Name" field in the Table Tools Design tab. This can make it easier to reference the table in formulas and functions.
  • Conditional Formatting: Excel allows you to apply conditional formatting to your table, which can visually highlight specific data points based on set criteria.

Using table features

When working with data in Excel, using tables can greatly enhance your ability to organize and analyze information. Here are some key features of Excel tables that can help you work more efficiently.

Show how to sort and filter data within the table

Sorting and filtering data within an Excel table allows you to quickly organize and view information based on specific criteria.

  • Sorting: To sort data within a table, simply click on the drop-down arrow in the header of the column you want to sort by, then select either "Sort A to Z" or "Sort Z to A" based on your preference.
  • Filtering: Filtering data within a table allows you to display only the rows that meet specific criteria. To apply a filter, click on the drop-down arrow in the header of the column you want to filter, then select the specific criteria you want to display.

Explain how to use the total row for quick calculations

The total row in an Excel table provides a convenient way to quickly calculate and display totals or other summary calculations for a column of data.

  • Adding the total row: To add the total row to your table, right-click anywhere within the table, then select "Table" and check the "Total Row" option.
  • Using the total row: Once the total row is added, you can use the drop-down menu within the total row to select the type of calculation you want to perform, such as sum, average, count, etc.

Customizing the table

After creating a table in Excel, you may need to customize it to better suit your needs. This can include adding or removing columns and rows, as well as formatting the table to improve readability.

Demonstrate how to add or remove columns and rows

Adding or removing columns and rows in a table is a simple process in Excel. To add a column, simply right-click on the column next to where you want to add the new column, and select 'Insert' from the drop-down menu. To remove a column, right-click on the column you want to delete and select 'Delete' from the drop-down menu. The same process applies for adding or removing rows.

Explain how to format the table to improve readability

Formatting the table is essential for improving readability. This can include adjusting the column width, changing the font style and size, adding borders, and applying shading to alternate rows to make the data easier to read. To format the table, select the entire table and then use the options in the 'Home' tab to customize the appearance of the table.


In conclusion, creating a table in an Excel sheet is a simple and effective way to organize your data. By using the "Insert Table" feature, you can easily format and customize your table to suit your needs. Remember to utilize the "Table Tools" tab for additional options and features. I encourage you to practice and explore the various functionalities of Excel for efficient data management.

Excel Dashboard

ONLY $99

    Immediate Download

    MAC & PC Compatible

    Free Email Support

Related aticles