Insert Title Rows into a Range in Excel Office 365!! – Kutools
Tags: kutoolsexceltutorial, stepstoinserttitlero, kutools
Published: 2020-10-08 12:03:07

---
title: Insert Title Rows into a Range in Excel Office 365!! – Kutools
published: true
date: 2020-10-08 07:03:44 UTC
tags: KutoolsExcelTutorial,StepstoInsertTitleRo,Kutools
canonical_url: https://geekexcel.com/insert-title-rows-into-a-range-in-excel-office-365-kutools/
---

In this article, you will understand the steps to **Insert Title Rows into a Range in Excel Office 365** using **Kutools.** Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Insert Title Rows into a Range:

To insert title rows into a range, do as follows.

- Let’s consider the below example data, you can see the column headers such as **Name, Id, Age, salary.** We are going to insert title rows using those columns headers.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-14.png)<figcaption id="caption-attachment-15421">Example</figcaption>

- On the **Kutools Tab, select** the **Insert** option, **choose** the **Insert Title Rows** option using the drop-down list.

![Select the Insert Title Rows option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Insert-Title-Rows-option.png)<figcaption id="caption-attachment-15422">Select the Insert Title Rows option</figcaption>

- It will open the **Insert Title Rows dialog box**.
- **Title range box** – You need to **select** the **input range** using the browse button given in the Title range box.
- **Insert range box ** – You need to specify the range that you want to insert title rows to each row of the data.
- **Interval row box ** – In this input box, you need to specify the number for inserting title rows for every **n<sup>th</sup> row**.

![Insert Title Rows dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Insert-Title-Rows-dialog-box.png)<figcaption id="caption-attachment-15423">Insert Title Rows dialog box</figcaption>

- **Click** the **OK** button. Now, all the **title rows have been inserted** into every **n<sup>th</sup> row**.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-15.png)<figcaption id="caption-attachment-15424">Output</figcaption>

## Verdict:

In the above article, you can clearly understand the steps to **Insert Title Rows into a Range in Excel Office 365** using **Kutools** with an example. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Show or Hide Zero Values in Excel](https://geekexcel.com/how-to-show-or-hide-zero-values-in-excel-office-365-with-example/)
- [Unfreeze Panes on Multiple Worksheets in Excel](https://geekexcel.com/unfreeze-panes-on-multiple-worksheets-in-excel-office-365/)