While making a dataset it is very important to make a title of the dataset. But sometimes it becomes critical when we have already made our dataset and don’t have the place to add the title. From now on it will not be a problem anymore. In this article, I have shared with you how to add a title to a table in Excel.
How to Add a Title to a Table in Excel: 3 Easy Steps
In the following section, I have shared 3 easy and simple steps to add a title to a table in Excel. To illustrate, I have taken a dataset containing some Student Names, their IDs, and Departments. Now, our goal is to add a title to this table in Microsoft Excel.
Step 1: Insert a Row at the Top of the Table
- Firstly, we will select the cell A1.
- After selecting the cell, right-click the mouse button to open the Context Menu.
- From the menu, choose “Insert”.
- A new window will pop up named “Insert”.
- From there choose “Entire row” and then press OK to continue.
Read More: How to Make a Title in Excel
Step 2: Type the Title According to Table
- As you can see a new row is created at the top of the dataset.
- Now type the title of your choice you want for your dataset.
Similar Readings
Step 3: Change Format of the Title
- After typing the title, it’s time to make the title look like a title.
- To do so, choose cells A1:D1 and click “Merge & Center” to merge all the cells and center the title name.
- Let’s make the title a little more lucrative.
- Selecting the title name press the “Bold” icon.
- Change the font to “14”.
- In this last step let’s fill the cell with a color of your choice.
- Finally, we have our dataset ready by adding a title at the top of the table.
Read More: How to Put a Title Across Cells in Excel
Things to Remember
- You can also add a title from the “Header and Footer” options. But it won’t appear in the dataset. It will appear at the time of printing.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Conclusion
In this article, I have tried to cover all the simple steps to add a title to a table in Excel. Take a tour of the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.
