In this article:

How to Change Google Sheets from Radians to Degrees (2024)

May 8, 2024

Google Sheets Radians to Degrees

In Google Sheets, to convert radians to degrees, you can use the formula:


This formula takes an angle in radians as the input and returns its equivalent in degrees. 

How to Change Google Sheets from Radians to Degrees

Follow the steps below to easily convert radians to degrees in Google Sheets. 

1. Select a Cell for Conversion

For our example, the radian values that we want to convert to degrees are listed under column A. Click on cell B2. This is where you'll input the formula to convert the first radian value from cell A2.

google sheets radians to degrees

2. Enter the Conversion Formula

In cell B2, type =DEGREES(A2). This formula converts the radian value in cell A2 from radians to degrees.

radians to degrees google sheets

3. Execute the Formula

Press Enter to apply the formula. Cell B2 will now display the conversion of 0.785 radians (a quarter turn) into degrees.

how to change google sheets from radians to degrees

4. Copy the Formula for Multiple Conversions

To convert the rest of the radian values, click on cell B2 again. Then drag the fill handle (the small square at the bottom-right corner of cell B2) down through to cell B9. This action copies the formula to each cell, automatically adjusting the formula to reference the correct cell in column A.

how to convert radians to degrees in google sheets

5. Verify the Converted Values

Review the degree values in column B to ensure they accurately reflect the conversion from the radians listed in column A. Each cell from B2 to B9 should now show the degrees equivalent of the radians from A2 to A9.

We hope that you now have a better understanding of how to change Google Sheets from radians to degrees. If you enjoyed this article, you might also like our article on the NPV formula in Google Sheets or our article on setting up Google Sheets dot product.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->