How To insert title in excel

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.

Table of Contents Show

Download Practice Workbook
3 Easy Steps to Add a Title to a Table in Excel
Step 1: Insert a Row at the Top of the Table
Step 2: Type the Title According to Table
Step 3: Change Format of the Title
Things to Remember
How do I add a title to excel?
How do I title a column in Excel?
How do I format text as title in Excel?

Table of Contents hide

Download Practice Workbook

3 Easy Steps to Add a Title to a Table in Excel

Step 1: Insert a Row at the Top of the Table

Step 2: Type the Title According to Table

Step 3: Change Format of the Title

Things to Remember

Conclusion

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

Add a Title to a Table.xlsx

3 Easy Steps to Add a Title to a Table in Excel

In the following article, I have shared 3 easy and simple steps to add a title to a table in excel. Stay tuned!

Suppose we have a dataset of some Student Name, their ID, and Department. Now we will 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).
Selecting the cell right click the mouse button to appear options.
From the options 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 Row in Excel (5 Easy Methods)

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.

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 (With Easy Steps)

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. Learn more.

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.

Add a title to your spreadsheet to clarify its contents and for better visual effect. To insert a title in a Microsoft Office Excel 2013 spreadsheet, add a header to the document. The header can also contain predefined information, such as page numbers, pictures and dates. Note that headers are printed when you print the spreadsheet. If you decide you don't need the header, you can remove it at any time.

Step 1

Open the spreadsheet in Microsoft Excel 2013, click the "Insert" tab and then click "Header & Footer" in the Text group to add a blank header to the top of each page of the spreadsheet.

Video of the Day

Step 2

Click inside the left, center or right "Click to add header" box and type the title of the spreadsheet. You can display the page number or total number of pages in any of the header boxes by clicking "Page Number" or "Number of Pages" in the Header and Footer Elements group. To add the current date or time, click "Current Date" or "Current Time." You can also insert a picture in the header by clicking "Picture." If you want to display the file path or file name, click "File Path" or "File Name."

Step 3

Click anywhere in the spreadsheet, click the "View" tab and then click "Normal" in the Workbook Views group to return to normal view. To view and edit the header, use the "Page Layout" view. The header is also visible in Print Preview view.

Tip

You can format the header elements by selecting the text, clicking the "Home" tab and then changing the settings in the "Font" group.

To add pictures from your computer, click the "Work Offline" button after you click "Picture" in the Header and Footer Elements group.

To remove the header completely, click "Header" in the Header and Footer group and click "None."

You can add multiple elements in the same header box. For example, you could add the current date and time in one of the boxes.

You may see formulas when you add predefined information in the header. Don't worry -- the correct information is displayed when you click anywhere outside the header box.

Remember, you can also display predefined information and pictures in the footer. To edit the footer, click the left, center or right "Click to add footer" box at the bottom of the page.

How do I add a title to excel?

Add a chart title manually.

Click anywhere in the chart to which you want to add a title. ... .

On the Layout tab, in the Labels group, click Chart Title..

Click Centered Overlay Title or Above Chart..

In the Chart Title text box that appears in the chart, type the text that you want..

How do I title a column in Excel?

Select a column, and then select Transform > Rename. You can also double-click the column header. Enter the new name.

How do I format text as title in Excel?

On the status bar, click the Page Layout View button. Select the header or footer text you want to change. On the Home tab in the Font group, set the formatting options that you want to apply to the header / footer. When you're done, click the Normal view button on the status bar.