The **X Bar** symbol is used in statistics frequently. Whenever working with Excel, you may face a situation where you will need to write *X Bar*. The focus of this article is to explain how to write *X Bar* in Excel.

## How to Write X Bar in Excel: 3 Easy Ways

Here, I have taken the following dataset to explain this article. It contains some letters. You will need to write their bars. I will explain how you can write *X Bar* in Excel in 3 easy ways.

### 1. Use Symbol Command to Write X Bar in Excel

In this first method, I will explain how you can use the **Symbol **command to write *X Bar* in Excel.

**Steps:**Â

- Select the cells where you want to write the
*X Bar*. Here, I selected the range**C4:C8**. - Go to the
**Home**tab from the**Ribbon**. - Click on the drop-down option for
**Font**.

- Next, select
**Arial**as the**Font**.

- Select cell
**C4**and write**X**. - Next, go to the
**Insert**tab andÂ select**Symbol**.

- The
**Symbol**dialog box will appear. - Select the drop-down option for
**Font**Â and select**Arial**.

- Click on the drop-down option for
**Subset**. - After that, select
**Combining Diacritical Marks**.

- Select
**Combining Overline**and press**Insert**.

- Select
**Close**in the dialog box.

- Now, you will see that you have written
*X Bar*in Excel.

- Next, write the
*Y Bar*in the same way.

- After that, select the cells where you want to write bars.
- Go to the
**Home**tab and click on the drop-down option for**Fill**. - Further, select
**Flash Fill.**

- Click on the
**Flash Fill Options**. - Then, select
**Accept suggestions**.

- Finally, you will get the desired output.

**Read More: **How to Insert Sign in Excel Formula

### 2. Employ the Equation Feature to Insert X Bar in Excel

You can also use the **Equation **feature in Excel to write the *X Bar*.

**Steps:**

- Go to the
**Insert**tab andÂ select**Equation**.

- Next, select
**Accent**from the**Equation**tab. - Select
**Bar**Â from the drop-down menu.

- The equation box will appear.
- Write
**X**or the letter you want.

- Next, double-click on the
*X Bar*. - Then, select
**Italic**to remove the italic font from the*X Bar.*

- After that, click and drag the
*X Bar*where you want it to be.

- Here, you can see that I have got my
*X Bar*in Excel.

- In the end, write the other data in the same way.

**Read More: **How to Insert Symbol in Excel Header

### 3. Copy and Paste X Bar from Browser to Write in Excel

The easiest way to write *X Bar* in Excel is to copy it from a browser.

**Steps:**

- First, search for the
*X Bar*symbolÂ in your browser. - Select the symbol and copy it by pressing
**Ctrl**+**C**on your keyboard.

- After that, select the cell where you want the
*X Bar*. Here, I selected cell**C4**. - Then, paste the
*X Bar*in the formula bar by pressing**Ctrl +****V**on your keyboard.

- Next, press
**Enter**and you will get the*X Bar*.

- Finally, write bars for other letters in the same way.

**Read More: **How to Insert Symbol in Excel FooterÂ

## How to Write P Hat in Excel

In this section, I will show you how you can write *P Hat* in Excel. I will use the **Symbol **feature for this section.

**Steps:**

- Select the cells where you want to write the symbols.
- Then, go to the
**Home**tab. - Next, select
**Arial**as the**Font**.

- Select the cell where you want to write
*P Hat*. - Then, write
**P**in the selected cell. - Next, go to the
**Insert**tab. - Next, select
**Symbol**.

- The
**Symbol**dialog box will appear. - Select
**Arial**as**Font**. - Choose
**Combining Diacritical Marks**as the**Subset**. - Next, select
**Combining Circumflex Accent**Â andÂ press**Insert**.

- Then, select
**Close**.

- After that, you will see that you have written
*P Hat*in Excel.

- Lastly, write the other symbols by following the steps from
**Method 1**.

## Practice Section

Here, I have provided a practice sheet for you to practice how to write* X Bar* in Excel.

**Download Practice Workbook**

You can download the practice workbook from here.

## Conclusion

So, you have reached the end of my article. Here, I tried to cover how to write *X Bar* in Excel in 3 easy ways. I hope this article was helpful to you. For more articles visit our website. If you have any questions, feel free to let me know in the comment section below.