Quick way to transform your data without using formulas

  • Excel
  • 2016
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:

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

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.

Transactions Tracking

  • Income
  • Expense
  • Transfer
  • Buy,Sell and Dividend
Track your finances at https://moneybench.net Try Now

Quick Overview

  • Income and Expenses
  • Assets and Liabilities
  • Investments
  • Net worth
Track your finances at https://moneybench.net Try Now

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.