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.

Video of the Day

Brought to you by Techwalla
Brought to you by Techwalla

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