# How to Write X Bar in Excel (3 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

### 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.

### 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.

## 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.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , and premium Excel consultancy services for Excel and business users. Feel free to contact us with your Excel projects.
Mashhura Jahan

Hey! Welcome to my profile. Currently, I am doing research on Microsoft Excel. I will be posting articles related to this here. My last educational degree was B.Sc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. I like to explore new things and find the best and most innovative solutions in every situation.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF