In this article, I will narrate how to insert square root symbol in Excel. The square root is one of the most used symbols in Excel.
I will show several ways. Choose the method that best suits your purpose.
Inserting square root symbol in Excel
1) Using Insert tab
This is the simplest way.
- At first, select the cell where you want to show the square root symbol.
- Now, open the Insert tab -> Symbols group of commands (the last one on the tab) -> Click on the Symbol command
- Symbol dialog box will appear. By default, as the Font, (normal text) will be selected. In the Subset (on the right side of the dialog box), choose Mathematical Operators. And you will find the square root symbol. Press the Insert command (bottom-right corner of the dialog box) and then choose the Close You’re done.
2) Using Character Code 221A in the Symbol dialog box
This process is almost the same as above.
- Select a cell (where you want to show the symbol)
- Open the Symbol dialog box (Insert tab -> Symbols group of commands->click on the Symbol command). The Symbol dialog box will appear.
- In the dialog box, select Unicode (hex) from the drop-down (at the bottom right corner of the dialog, just above the Cancel button). In the Character code field type 221A. Square root symbol will be selected.
- Now press Insert and Close button respectively.
3) Using Excel Function UNICHAR (8730)
You can also use the UNICHAR function (with code 8730) of Excel to insert the square root symbol in Excel. See how I have used this function (image below).
4) Keyboard Shortcut ALT + 251
- Take a cell to the edit mode and select the position where you want to put the square root symbol.
- Now press ALT + 251 on the keyboard. The symbol will be placed.
- Finally, press Enter key on the keyboard.
5) Using keyboard shortcut ALT + N + U
This is also good.
- Press ALT + N + U on your keyboard. The Symbol dialog box will appear with the square root symbol selected in the dialog box.
- Now just Insert the symbol and then Close the dialog box. A straight-forward method.
6) Using Custom Number Format
This method and the next one (using VBA) can be used to insert the square root symbol in more than one cell (at a time).
- Select the cells where you want to insert the square root symbol.
- Now open the Format Cells dialog box clicking on the little arrow on the bottom right corner of the Number group of commands.
- Select the Custom option from the left pane. And put your cursor before the General format and press ALT + 251 on your keyboard.
- Now press OK and see what has happened. All the numbers are now having the square root symbols before them.
7) Using Excel VBA
To use this method, you have to save your Excel file with the extension .xlsm. Because .xlsx files cannot deal with VBA code. If you don’t like to use VBA code in your Excel file, then avoid this method.
- Open the Visual Basic Editor (Developer tab -> Code window -> Select the Visual Basic command)
- In the editor, insert a new module.
- In the module window, insert the following code:
Sub square_symbol()
Selection.NumberFormat = ChrW(8730) & "General"
End Sub
- Now close the Visual Basic editor and save the workbook (CTRL + S).
- Let’s now select some cells that have some numbers.
- Now go to Developer tab -> Code window -> click on Macros command -> Macro dialog box will appear -> In the dialog box, select the macro (square_symbol) -> click on the Run
- You see all the numbers now have the square root symbols.
Working File
Related Readings
- How to insert Equation in Excel using Equation Editor (Easy Guide)
- Excel Formula Symbols Cheat Sheet (13 Cool Tips)
Conclusion
So, these are my ways to insert the square root symbol in Excel cells. Do you know any other way? I am eager to know. Let me know in the comment box.