How to share or paste data without a formula in Excel.

Today we are discussing. How to share or paste data without a formula and how to show another person, because when we share data with the formula, there are many chances of losing or conflicting with other data, and data shows wrong information. Once you are what you get done using formulas to get the desired results, so after you may want to remove the formulas and keep the data you got as a result of using these formulas. Another scenario could be when you are sending your Excel file to someone else and want to avoid confusion or protect your formulas from being accidentally changed or stolen by other.

Method 1: Paste Values Only Using keyboard Shortcut

If you want paste data without code or Sourced code of formulas using shortcut. So you can use Ctrl + Alt + V In Microsoft Excel and in the “Paste Special” dialog box, select “Values” or ” Press V Second time and press enter. If your Using in Google Sheet, So you can use only  Ctrl + Shift + V. This will paste the data into Excel without the formulas, retaining only the values.

Method 2: Paste Values Only

1. Copy the data you want to paste into Excel.
2. Select the cell or range of cells in Excel where you want to paste the data.
3. Right-click on the selected cell(s) and choose “Paste Special” from the context menu.
4. In the “Paste Special” dialog box, select “Values” or “Values and Number Formats” (depending on your preference) from the options.
5. Click the “OK” button.

Method 3: Use the “Paste” Options Button

1. Copy the data you want to paste into Excel.
2. Select the cell or range of cells in Excel where you want to paste the data.
3. Right-click on the selected cell(s) and choose “Paste” from the context menu.
4. After pasting, a small “Paste Options” button will appear near the pasted data.
5. Click on the “Paste Options” button, and choose “Values” or “Values and Number Formats” (depending on your preference).

Method 4: Paste and Clear Excel Formulas

1. Copy the data you want to paste into Excel.
2. Select the cell or range of cells in Excel where you want to paste the data.
3. Paste the data using Ctrl+V or right-click and select “Paste.”
4. After pasting, select the cell(s) containing the pasted data.
5. Go to the “Home” tab on the Excel ribbon.
6. In the “Editing” group, click on the “Clear” button.
7. From the dropdown menu, select “Clear Formulas.”

This above all method involves pasting the data normally and then explicitly clearing the formulas from the pasted cells.