How to Write X Bar or Hat in Excel (4 Methods)

The X Bar symbol is used in statistics frequently.


Dataset to Write X Bar in Excel


Method 1 – Use Symbol Command to Write X Bar in Excel

Steps: 

  • Select the cells where you want to write the X Bar. (In the example below, the selected range is C4:C8).
  • Go to the Home tab from the Ribbon.
  • Click on the drop-down option for Font.

Use Symbol Command to Write X Bar in Excel

  • Select Arial as the Font.

Changing Font to Write X Bar in Excel

  • Select cell C4 and write X.
  • Go to the Insert tab and select Symbol.

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

Selecting Font for Symbol to Write X Bar in Excel

  • Click on the drop-down option for Subset.
  • Select Combining Diacritical Marks.

Selecting Subset for Symbol to Write X Bar in Excel

  • Select Combining Overline and press Insert.

  • Select Close in the dialog box.

  • The X Bar Symbol will show in the selected Excel cell (In the below example cell C4).

  • To write the Y Bar follow the same steps above.

  • To write multiple Bars select the cells where you want to write Bars.
  • Go to the Home tab and click on the drop-down option for Fill.

Using Flash Fill to Write X Bar in Excel

  • Click on the Flash Fill Options.
  • Select Accept suggestions.

  • The Bar symbol’s will appear within the selected cells (in the below example cells C5 to C8).

Read More: How to Insert Sign in Excel Formula


Method 2 – Employ the Equation Feature to Insert X Bar in Excel

Steps:

  • Go to the Insert tab and select Equation.

Employ Equation Feature to Insert X Bar in Excel

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

  • Double-click on the X Bar.
  • Select Italic to remove the italic font from the X Bar.

  • Click and drag the X Bar where you want it to be.

  • The X Bar will shown in selected cell (in the below example shown in cell C4).

  • For the remaining data, repeat these steps using the letters Y, P, M, Z or as required.


Method 3 – Copy and Paste X Bar from Browser to Write in Excel

Steps:

  • Search for the X Bar symbol in your browser (in the below example Google is shown).
  • Select the symbol and copy it by pressing Ctrl + C on your keyboard.

Copy and Paste X Bar from Browser to Write in Excel

  • Select the cell where you want the X Bar. Here, I selected cell C4.
  • Paste the X Bar in the formula bar by pressing Ctrl + V on your keyboard.

  • Press Enter and you will get the X Bar.

  • Write bars for other letters in the same way.

Read More: How to Insert Symbol in Excel Footer 


Method 4 – How to Write P Hat in Excel

The Symbol feature will be used for this section.

Steps:

  • Select the cells where you want to write the symbols.
  • Go to the Home tab.
  • Select Arial as the Font.

How to Write P Hat in Excel

  • Select the cell where you want to write P Hat.
  • Write P in the selected cell.
  • Go to the Insert tab.
  • Select Symbol.

  • The Symbol dialog box will appear.
  • Select Arial as Font.
  • Choose Combining Diacritical Marks as the Subset.
  • Select Combining Circumflex Accent and press Insert.

  • Select Close.

  • You have now written P Hat in Excel

  • Write the other symbols by following the steps from Method 1.


Practice Section

Here’s a sheet you can use to practice writing X Bar in Excel

Practice Sheet for How to Write X Bar in Excel


Download Practice Workbook

You can download the practice workbook from here.


Related Articles


<< Go Back to Mathematical Symbols in Excel | Insert Symbol in Excel | Excel Symbols | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mashhura Jahan
Mashhura Jahan

Mashhura Jahan, BSc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology, invested 1.5 years at ExcelDemy. In roles like Excel & VBA Content Developer, Excel Charts, and Dashboard course trainer, she wrote 90+ articles. She was previously part of the forum support team and a junior software analyst on the Excel Add-in project. With interests spanning Excel, VBA, Power Query, Python, Data Science, and Software Development, Mashhura brings a diverse skill set to her... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo