Learn how to quickly and easily calculate the degrees Celsius in Excel without using a function.

When working with data and numbers in Excel, displaying degrees Celsius is an important factor, especially for those working in fields such as science, weather, or anyone needing to track temperature. In this article, we will explore how to write degrees Celsius in Excel in a simple and effective way.

What is Celsius?

Celsius (abbreviated as °C) is a unit for measuring temperature in the International System of Units, also known as the Metric System. It is widely used worldwide to measure temperature and is one of the most common units of temperature measurement.

Celsius is based on the temperature range of water. In this system, the freezing point (the temperature at which water freezes) is set at 0 degrees Celsius and the boiling point (the temperature at which water boils under 1 atmosphere of pressure) is set at 100 degrees Celsius. This range is divided into 100 parts using the interval division method.

Celsius is used in various contexts, including temperature standards for everyday activities such as measuring environmental temperature, human body temperature, and cooking processes. This makes Celsius an important unit of measurement and commonly appears on temperature measuring devices and in spreadsheets, reports, and measuring applications.

How to write degrees Celsius in Excel

There are several ways to write degrees Celsius in Excel. Therefore, you should choose the method that suits your spreadsheet. Now, let’s go into detail about each method of writing degrees Celsius in Excel.

Method 1: Copy the Celsius symbol from other sources

One of the simplest ways to write degrees Celsius in Excel is to copy the Celsius symbol from other sources and paste it into your spreadsheet. Here is a detailed guide on how to do this method:

Step 1: Open your favorite browser on your computer. Then, search for the keyword “degrees Celsius” on Google. This is the simplest keyword to find the Celsius symbol. However, you can expand your keyword as you like. Just make sure the end result is still the Celsius symbol.

Step 2: Choose any source returned by Google that displays the Celsius symbol. Right-click on it and select Copy in the menu options. You can also use the keyboard shortcut Ctrl + C to perform the same action.

Step 3: Go back to your spreadsheet. Select the cell where you want to display the Celsius data. Then, right-click on it and select the Paste option to paste the Celsius symbol into the cell. Alternatively, you can use the keyboard shortcut Ctrl + V to perform the same action.

Result: You will see the Celsius symbol (°C) inserted in the Excel cell. Now, you can enter or change the temperature value before this character.

Method 2: Use the Symbol tool to insert the Celsius symbol

The Symbol tool is a default integrated tool of Excel. Here is a detailed guide on how to write degrees Celsius in Excel using the Symbol tool:

Step 1: First, you need to identify the cell in Excel where you want to display degrees Celsius. Make sure you have selected the correct cell before proceeding to the next steps.

Step 2: Click on the Insert tab on the Excel toolbar. In the Symbols group, choose Symbol. This action will open the Symbol dialog box, where you can find and insert the Celsius symbol for your data cell.

Step 3: In the Symbol dialog box, select the appropriate font for the Celsius symbol (e.g. Times New Roman). Then, find and select the degree symbol (°) from the list of available characters. You can scroll to search more easily. Click the Insert button to insert the degree symbol into your data cell.

Step 4: You will see the degree symbol (°) inserted in the Excel cell. Now, you can enter or change the temperature value before this character and the letter C.

Method 3: Change character formatting

In addition to searching for Celsius symbols in the above 2 methods, you can also change the display formatting in the data cell to convert the character (o) to (°). Here is a detailed guide on how to do this method:

Step 1: Move the mouse cursor to the position where you want to write degrees Celsius in the Excel cell. Then, right-click and select Format Cells… in the menu options.

Step 2: In the Format Cells dialog box that appears, click the checkbox to select the Superscript formatting option. Then, click OK to apply the formatting change. This action will change the display of the character in the cell.

Step 3: Type the letter O on the keyboard. You will see this character raised and displayed like the (°) character in the Celsius symbol.

Step 4: Continue, right-click and select Format Cells… in the menu options to adjust the cell formatting.

Step 5: In the Format Cells dialog box that appears, uncheck the checkbox to stop using the Superscript formatting. Then, click OK to apply the formatting change. This action will restore the characters to normal formatting.

Step 6: Type the letter C on the keyboard. You will see this character returned to normal formatting to display the Celsius symbol.

Conclusion

Whether you are a scientist, someone working in the weather field, or simply an average Excel user, knowing how to write degrees Celsius in Excel will always be a useful skill. This little trick will help you work with temperature-related data accurately and easily, while creating clarity and visual appeal to your spreadsheet.