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.

**Table of Contents**hide

## Download Practice Workbook

You can download the practice workbook from here.

## 3 Easy Ways to Write X Bar in Excel

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. Let’s explore the steps.

**Steps:**

- Firstly, select the cells where you want to write the
**X Bar**. Here, I selected the cell range**C4:C8**. - Secondly, go to the
**Home**tab from the**Ribbon**. - Thirdly,
**click**on the drop-down option for**Font**.

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

- Then, select the cell where you want to write the
**X Bar**. Here, I selected**Cell C4**. - Next, in
**Cell C4**write**X**. - Afterward, go to the
**Insert**tab. - Further, select
**Symbol**.

- Consequently, the
**Symbol**dialog box will appear. - Select the drop-down option for
**Font**. - Then, select
**Arial**.

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

- Then, select
**Combining Overline**. - Next, select
**Insert**.

- Afterward, 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**. - Then, go to the
**Home**tab. - Next,
**click**on the drop-down option for**Fill**. - Further, select
**Flash Fill**.

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

- Finally, you can see that, I have got my desired output.

**Read More: ****How to Overline Text in Excel (4 Easy Ways)**

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

You can also use the **Equation **feature in Excel to** write X Bar**. Let me show you how you can do that.

**Steps:**

- In the beginning, go to the
**Insert**tab. - Then, select
**Equation**.

- Next, select
**Accent**from the**Equation**tab. - Then, a drop-down menu will appear.
- Select
**Bar**.

- Consequently, an 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 WordArt in Excel (2 Simple Methods)**

**Similar Readings**

**How to Insert Clipart in Excel (4 Easy Ways)****Create Double Entry Bookkeeping in Excel****How to Drill Down in Excel Without Pivot Table (With Easy Steps)****Calculate Bootstrapping Spot Rates in Excel (2 Examples)****How to Edit Document Properties in Excel (with Detailed Steps)**

### 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. Let’s see the steps.

**Steps:**

- First, search for
**“X bar symbol”**in your browser. - Next, select the symbol and then 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 Create a Word Cloud in Excel (2 Easy Ways)**

## 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. Let’s see the steps.

**Steps:**

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

- After that, select the cell where you want to write
**P Hat**. - Then, write
**P**in the selected cell. - Next, go to the
**Insert**Tab. - Subsequently, select
**Symbol**.

- Now, the
**Symbol**dialog box will appear. - Select
**Arial**as**Font**. - Then, select
**Combining Diacritical Marks**as**Subset**. - Next, select
**Combining Circumflex Accent**. - Afterward, 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**.

**Read More: ****How to Do Descriptive Statistics in Excel (2 Suitable Methods)**

## Practice Section

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

## 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 **ExcelDemy**. If you have any questions, feel free to let me know in the comment section below.

**Related Articles**

**How to Show Menu Bar in Excel (2 Common Cases)****Use of Task Pane in Excel (Detailed Analysis)****How to Change 1000 Separator to 100 Separator in Excel****Show Full Cell Contents on Hover in Excel (5 Quick Ways)****How to Check If Value Is Between 10 and 20 in Excel****Mark Workbook as Final in Excel (with Easy Steps)****How to Move Data from Row to Column in Excel (4 Easy Ways)**