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

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.


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.

Dataset to Write X Bar in Excel


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.

Use Symbol Command to Write X Bar in Excel

  • Next, select Arial as Font.

Changing Font to Write X Bar in Excel

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

Selecting Font for Symbol to Write X Bar in Excel

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

Selecting Subset for Symbol to Write X Bar in Excel

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

Using Flash Fill to Write X Bar in Excel

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

Employ Equation Feature to Insert X Bar in Excel

  • 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


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.

Copy and Paste X Bar from Browser to Write in Excel

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

How to Write P Hat in Excel

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

Practice Sheet for 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

Mashhura Jahan

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

Leave a reply

5 Excel Tips
You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo