Quick way to transform your data without using formulas

Excel 365
Sometimes, especially when you work with a lot of data, you need to transform it. If you need to convert some range of data by dividing or multiplying it, it can be done in Excel in two clicks:

The first step, the most important: preparing data

  • Prepare the source data range that you want to be transformed, for example:
    Data range in Excel 2016
  • Prepare the data range by which your data should be multiplied or divided, for example:
    Data range for change in Excel 2016

The second step: transformation in 2 clicks

   1.   Select your data range and then copy it by doing one of the following:

  • On the Home tab, in the Clipboard group, click Copy:
    Clipboard in Excel 2016
  • Press Ctrl+C.

   2.   Select the second data range, with which the copied data should be transformed.

   3.   On the Home tab, in the Clipboard group, click on the Paste dropdown list and then choose Paste Special...:

Clipboard group in Excel 2016

   4.   In the Paste Special dialog box, check the appropriate Operation, you want to apply to the copied data:

Paste Special dialog box in Excel 2016

For example, after selecting Multiply:

Data range changed in Excel 2016

Using these easy and quick steps, you can:

  • Convert data from one currency to another:

    If you need to multiply, divide, add or subscribe the simple amount, first select that amount and then paste it to the range:

    Prepared data:

    Convert data from one currency to another in Excel 2016

    Results after the Multiply operation:

    Result: Convert data from one currency to another in Excel 2016
  • Multiply any data range to different coefficients like showed above;
  • Convert original amounts to convenient amounts (thousands, billions, millions, etc.):

    Prepared data:

    Convert original amounts to convenient amounts in Excel 2016

    Results after the Divide operation:

    Result: Convert original amounts to convenient amounts in Excel 2016
  • etc.

See also this tip in French: Un moyen rapide de transformer vos données sans utiliser de formules.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.