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.
Preparing Yellow Apricot Flowers to be in Full Bloom for Tet Celebration
As the Lunar New Year quickly approaches, many families are looking for guidance when it comes to selecting, purchasing, maintaining, and decorating with beautiful golden apricots. To ensure you get the most out of this lovely tradition, this article will provide you with specific instructions for choosing, caring for and decorating with yellow apricot blossoms. Learn how to make the most of this iconic symbol of the Tet holiday season!
Discover Unusual Ironing Techniques to Improve the Appearance of Clothing
If you’re looking to achieve a pristine, wrinkle-free appearance to your clothes, then ironing is a must-have in any household. But are you aware of the different techniques and tricks out there that can help you save energy, maintain the life of your ironing board, and do a better job ironing? In this article, we’ll be unlocking the secrets to some of the best ironing hacks that you won’t find anywhere else.
How to Maximize Air Conditioning Comfort for Babies in the Home
Having a new baby in the home brings many considerations and responsibilities, none more important than making sure the baby is safe and healthy. One way to achieve this is proper air conditioning usage. Read on for helpful tips on how to make the best use of air conditioners to keep your newborn safe.