How to Get the Mean Symbol in Excel

by Aksana Nikolai

The symbol consisting of an “x” with a bar on top of it represents the mean, or average, of a set of numbers. There is no need to print off your Excel spreadsheets and hand-write the mean symbol when working with statistical data. Doing so can be time-consuming when working with spreadsheets that contain dozens or hundreds of pages. You can insert the mean symbol in Excel by editing the font settings within the “Symbol” menu.

1

Select the cell to which you want to add the mean symbol.

2

Click the "Insert" tab, and select "Symbol" from the "Text" group to open the "Symbol" pop-up window.

3

Select "MS Reference Sans Serif" from the "Font" drop-down menu within the "Symbol" pop-up window.

4

Enter "F7C2" into the "Character Code" field. Select "Unicode (Hex)" using the "From" drop-down menu.

5

Click "Insert" to add the mean symbol to the selected cell.

About the Author

Aksana Nikolai is a graduate of the New York Institute of Technology with a bachelor's degree in language studies and international affairs. Nikolai is currently working in online marketing and communications. She has been writing since 2008, specializing in made-for-Web content and maintaining her fashion and beauty blog.

More Articles

Photo Credits

  • photo_camera Hemera Technologies/AbleStock.com/Getty Images