Enter average characters in Excel
The well-known average symbol - the crossed-out circle - is not found on any keyboard. In this article, we will tell you how you can still enter the special character in Excel.
Excel: Enter the average character
In Windows, you can enter the average sign in two ways.
- The quickest way to insert the average character is with a key combination: To do this, hold down [Alt] and type in the numbers [0216] one after the other using the number pad.
- Alternatively, you can copy the symbol from the character table. To do this, switch to the "Insert" tab in Excel and click on "Symbol" on the right. Here double tap on the average sign to insert it at the current position.
Become an Excel professional with the new course at the CHIP Academy
With the course in the CHIP Academy "Excel: Pivot tables in less than an hour" even beginners learn how to handle a large amount of data quickly and easily.
- Learn in 40 minutes from our lecturer Daniel Kogan what pivot tables are and how to use them sensibly.
- You will learn how to use pivot tables and pivot charts to gain insights and insights from your data that you would otherwise not have been able to access.
- Visit the CHIP Academy and get the extensive online video workshop for 19.90 euros.
With Excel you don't just calculate the average of different values. In the next practical tip, we will explain how you can also calculate the checksum with Excel. This article applies to Excel 2013.