How to Do Data Scaling in Excel (3 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

If you are looking for special tricks to know how to scale data in Excel, you’ve come to the right place. There are numerous ways to do scaling data in Excel. This article will discuss the details of 3 methods to do this task in Excel. Let’s follow the complete guide to learn all of this.

How to Do Data Scaling in Excel: 3 Easy Methods

In the following section, we will use three effective and tricky methods to scale data in Excel. This section provides extensive details on these methods. For our demonstration, we’ll use the dataset below, which includes student names and corresponding grades. We will now scale the data in the Marks column according to our preferences.

sample dataset

You should learn and apply these to improve your thinking capability and Excel knowledge. We use the Microsoft Office 365 version here, but you can utilize any other version according to your preference.

1. Combine MIN and MAX Functions to Scale Data in Excel

Here, we are going to demonstrate how to scale in Excel using MIN and MAX functions. In Microsoft Excel, the MIN function is generally used to extract the lowest or smallest value from a range of cells containing numerical data only. As part of Excel STATISTICAL functions, the MAX function returns the largest value among the arguments given. Let’s walk through the following steps to do the task.

📌 Steps:

  • First, to scale the Marks column data write down the following formula.


  • Next, press Enter.
  • Therefore, you will get the following scaling data.

use MIN and Max functions to Do Data Scaling in Excel

  • Next, drag the Fill Handle icon to fill the other cells with the formula.
  • Consequently, you will get the following scaling data of the Marks column.

Data Scaling in Excel

💡 Note:

  • The MIN function does not count blank cells, so it will not return a blank cell if your chosen range of cells includes one. Instead, it will take the least significant value from all other non-empty cells.
  • You can input up to 255 arguments into the MIN function.

🔎 How Does the Formula Work?

  • C5-MIN(C:C): Once the minimum value of the C column has been determined and subtracted from cell C5, the formula C5-MIN(C:C) will return the value of 33.
  • (MAX(C:C)-MIN(C:C): This formula will yield the result of 62 after calculating the maximum value of the C column and deducting the minimum value from the maximum value.
  • (C5-MIN(C:C))/(MAX(C:C)-MIN(C:C)): Finally the whole formula will return the scale value of 0.532.

2. Perform Data Scaling Through Paste Special Feature

In this method, we will demonstrate how to perform data scaling through the paste special feature. In order to demonstrate our point, we will use the same dataset in this instance. Follow the following process to complete the task.

📌 Steps:

  • First, copy the data from the Marks column and paste it into the Scaling Data column.

use paste special feature to Do Data Scaling in Excel

  • After that, enter 100 in any cell, copy it, choose the cell you would like to scale, and then right-click on the cells and choose Paste Special from the menu that appears.

click on paste special

  • Therefore, Paste Special window will appear.
  • Next, select Divide from the Operation option.
  • Then, click on OK.

  • As a result, you will receive the Marks column scaling data listed below.

Do Data Scaling in Excel

Read More: How to Scale Data from 1 to 10 in Excel

3. Apply AVERAGE & STDEV Functions

In this method, we will apply AVERAGE and STDEV functions to scale data. In Excel, the AVERAGE function falls under the statistical functions category and provides the average value of an input argument. Using the STDEV function in Excel, the standard deviation of any data collection can be calculated. In this case, we will scale a collection of data values so that their mean is 0 and their standard deviation is 1. We use the same dataset in this case to illustrate our point. To accomplish the task, use the steps below.

apply average and stdev functions to Do Data Scaling in Excel

📌 Steps:

  • First, to calculate the mean value, write down the following formula.


  • Next, press Enter.
  • Therefore, you will get the following average value.

calculate mean value

  • Next, to calculate the standard deviation value, write down the following formula.


Here, C15 is the mean value, and C16 is the standard deviation value.

  • Then, press Enter.
  • Therefore, you will get the following standard deviation value.

  • Next, to calculate scale data value, select the cell and write down the following formula.


  • Then, press Enter.
  • Therefore, you will get the following scale data value.

  • Next, drag the Fill Handle icon to fill the other cells with the formula.
  • As a result, the scaling information for the Marks column will be as follows.

perform Data Scaling in Excel

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article. It contains all the datasets in different spreadsheets for a clear understanding. Try it yourself while you go through the step-by-step process.


That’s the end of today’s session. I strongly believe that from now you may be able to perform scaling data in Excel. If you have any queries or recommendations, please share them in the comments section below. Don’t forget to check our website for various Excel-related problems and solutions. Keep learning new methods and keep growing!

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Saquib Ahmad Shuvo
Saquib Ahmad Shuvo

Welcome to my Profile. I am working on and researching Microsoft Excel right now, and I will be posting articles about it here. I received a B.Sc. in Naval Architecture and Marine Engineering from the Bangladesh University of Engineering and Technology (BUET). Having studied naval architecture, I have a strong interest in research and development. Always try to learn from different sources and come up with creative solutions.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF