How to convert Celsius to Fahrenheit in Excel

 Then you can convert Celsius to Fahrenheit in Excel using a formula or function in Excel with a very simple implementation. The article below will guide you how to convert degrees Celsius to degrees Fahrenheit in Excel.

Convert Celsius to Fahrenheit in Excel using formula

First of all, you must remember that 0 °C = 32 °F, every 1 degree Celsius increase + 1.8 degrees Fahrenheit and every 1 degree Celsius decrease - 1.8 degrees Fahrenheit. The formula to convert Celsius to Fahrenheit in Excel is Number of degrees Fahrenheit = Number of degrees Celsius * 1.8 + 32.

Enter the calculation formula in the box then press Enter to get the result.

How to convert Celsius to Fahrenheit in Excel Picture 1

As a result, we get degrees Fahrenheit as shown below. You drag the first result cell down to the remaining cells to complete the Celsius to Fahrenheit conversion table in Excel.

How to convert Celsius to Fahrenheit in Excel Picture 2

How to convert Celsius to Fahrenheit in Excel using the Convert function

We have the Convert function formula = CONVERT (Number, From_Unit, To_Unit). In there:

1. Number: is the converted value
2. From_Unit: unit to convert
3. To_Unit: conversion unit

You enter the function formula into the data table in Excel to change. The units used in the Convert function must be placed in double quotes as shown.

How to convert Celsius to Fahrenheit in Excel Picture 3

Then we press Enter and you will also see the result of degrees Fahrenheit being converted from degrees Celsius.

How to convert Celsius to Fahrenheit in Excel Picture 4

Finally, we just need to drag the first result cell down to the remaining cells to display it as shown below.

How to convert Celsius to Fahrenheit in Excel Picture 5

Micah Soto

Update 21 February 2024