Now we have a new column with square roots of the number we have in the first column.

From here, you need to delete the first column of original values. So, right click on it and click remove.

After that, go to the home tab and click on close and load too.

Here you get a window to load data. First of all, select the existing worksheet and add range B1. Second, tick mark "Add to the Data Model".

As I said, this table is dynamic.

When you enter a new value in the original data table it calculates it’s square root automatically in your new table when you refresh it.

And, we are not using any type of formula here.

[Bonus Tip] How to Add SQUARE Root Symbol in Excel

Once you calculate a square root from a number, the next thing you can do is to add a square root symbol.

And for this, we have two different ways which we can use.

#1. Using a Shortcut Key

A simple way to add a square root symbol is the shortcut key and the shortcut is Alt + 251.

You need to hold down the Alt key as you type 251 on the numeric keypad. and once you release the Alt key, and the symbol appears.

#2. Add a SQUARE Root Symbol by Applying Custom Formatting

This is the most effective way to add a symbol.

All you need to do is, select all the cells, open custom formatting option and add formatting into the formatting input bar.

√General

In the end, click OK.

#3. VBA to Add a Square Symbol

You can also use below VBA code to apply a custom formatting to all the cells in the selection.

Sub Radical()

Selection.NumberFormat = ChrW(8730) & "General"

End Sub

Note: The benefit of using #2 and #3 method is you don’t need to add a symbol to all the cells one by one and when you add a symbol to a cell the value in the cell become a text and can’t be used further as a number.

Calculate Ratio in Excel: When it comes to Excel, we don’t have any specific single function which can help us to calculate a ratio. But, you can calculate it using some custom formulas [...]

Weighted Average in Excel: But, I have found the best way is to use formula by combining SUMPRODUCT and SUM functions. This method is simple and easy to apply [...]

Compound Interest in Excel: Compound interest is one of the most important financial calculations which most of us often do in our work. And, it’s must to learn to calculate it in Excel [...]

Insert/Type Degree Symbol in Excel: If you use a laptop like me, you’ll find that there is no key to type a degree symbol. While working on some data I have found that in Excel you can enter it using five different ways […]

Multiply using Paste Special: Sometimes in Excel, you need to perform some quick calculations. And, you can use paste special for these quick calculations instead of formulas […]

Calculate Age in Excel: In Excel, by using a person's DOB, you can calculate his/her age by using DATEDIF function [...]

Average TOP 5 Values in Excel: To average the top 5 scores from the list, you can use a formula based on the combination of LARGE and AVERAGE [...]

About the Author

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.

I haven’t mentioned it, but I enjoy going through your weekly emails to me, which also lead me on to explore so much more on your websites – and then I spend hours tinkering around with my own Excel files and modifying them.

It’s very satisfying – how I wish I had discovered tutorials like yours many years ago. I am not very good at Excel but the more I explore, the more I like it.