You will have a hard time if you ever need to insert any special character or symbol in Google Sheets as there is no built-in method to do that. In terms of mathematical calculations, the square root symbol (√) is very useful. Don’t worry, here we will show you some easy approaches on how to insert the square root symbol in Google Sheets.
A Sample of Practice Spreadsheet
You can make a copy of our datasheet from the download button below to practice yourself.
3 Easy Ways to Insert Square Root Symbol in Google Sheets
Assume you have a simple dataset that just contains 2 rows and 2 columns. The first column is for Symbol Names and the second column is for the corresponding Symbols. Here is a glimpse of the dataset. Suppose you need to insert the square root symbol in the symbol column.
Follow the methods given below to get your required symbol.
1. Apply Keyboard Shortcut to Insert Square Root Symbol
You can easily insert a square root symbol using a keyboard shortcut in Google Sheets. Just follow the step-by-step techniques below to do that.
- First, double-click on cell C5 and put the cursor where you want to insert the symbol.
- Then, press Alt+251 from the numeric pad, release the Alt key, and press enter. In this way, you will get the square root symbol in the desired cell.
2. Insert Square Root Symbol Using UNICHAR Function
There is another useful way in Google Sheets to insert the square root symbol. There is a built-in UNICHAR function in Google Sheets which works under specific ASCII codes. For the square root symbol, the code is 8730.
- First, apply the following formula in cell C5 to insert the square root symbol.
- Now, if you want to insert the symbol with a number you have to modify the formula as shown below.
- There is another way to insert the square symbol with a number and also show the output. To do that you have to modify the formula using the ampersand symbol (&) as follows.
3. Use Copy-Paste Feature to Insert Square Root Symbol
Using the copy-paste feature is probably the most common way to insert any symbol or special character like the square root in Google Sheets. There are some different ways to do that as discussed below.
3.1 Using Google Docs
In this method, we will copy the square root symbol from Google Docs and then enter it in Google sheets.
- First, open a Google Doc on your computer. After that go to the Insert tab in the ribbon and click on the Special Characters options.
- Then go to the Search Box in the popped-out window to search for the name of your desired symbol.
- After that, type Square Root in the search box, and the symbol will show. Then, click on the square root symbol to insert it into the Google Doc file.
- Now, the required symbol has been placed in your Google Doc file. Copy the symbol using CTRL+C.
- Finally, open your Google Sheet and double-click the cell C5 where you want to insert the square root symbol and paste it using CTRL+V.
3.2 Using Windows Character Map
Copying special characters using Windows Character Map can be an effective alternative way. Follow the given steps to copy the Square Root symbol from Windows Character Map.
- First, enter “Character Map” in the search box on your computer. Then find and select the Character Map app from the list of results.
- Then check the Advanced View checkbox.
- Now, search for the square root symbol in the Search Box and then select it.
- After that, make a copy of the selected symbol by pressing the Copy button.
- Then, select the cell in Google Sheets where you want to insert the square root symbol and paste it using CTRL+V.
3.3 Performing Google Search
As an alternative, you may just use your web browser to perform a Google search for the square root symbol. Then grab the symbol for the square root from the search results. The copied symbol should then be pasted into the applicable Google Sheets cell.
How to Get the Square Root of a Number in Google Sheets
You can also use the SQRT function in Google Sheets to get the square root of numbers. For example, it will convert 16 to 4, 81 to 9, and so on. Follow the steps below to be able to do that.
- First, simply apply the formula given below in cell C5. Here cell B5 contains 100. So the formula returns 10 as it is the square root of 100.
- Now, just drag the fill icon and you will get the square root value of the entire column.
Things to Remember
- You must type the ALT key code from the numeric pad. Otherwise, the shortcut may not work.
- Double-click on the symbol for selecting from the character map.
These are the three different ways to put the square root symbol in Google Sheets. Personally, I believe that if you frequently need to insert special characters in Google Sheets, using the Alt code is the best choice. Although the alternate approach, copy/paste, will work just fine if you don’t want to memorize the codes. Please provide your preferred way of inserting the square root symbol in Google Sheets in the comments section. You are always welcome to visit our OfficeWheel website if you want to learn more about the many strategies for using Google Sheets.