How to copy value without formula in Excel One of the most common uses for Microsoft Excel is to store and calculate numerical data. However, it can be frustrating when you want to copy values from a formula-based cell, but instead of the value, you end up with a new formula that references the original cell. Fortunately, there are several ways to avoid this problem.
How to Copy/Paste Values Without the Formula in Excel
1. Select the cell or cells that you want to copy and press Ctrl + C (Windows) or Command + C (Mac).
2. Right-click on the destination cell where the values should be pasted and select Paste Special from the menu.
3. In the Paste Special dialog box, tick Values, then click OK.
4. Your values will now be pasted into the destination cell without any formulas.
Alternatively, you can use the Copy and Paste menu items on the Home tab of the ribbon. Select your source cells, then choose Copy from the Clipboard group of the Home tab.
How to Copy/Paste Value from Cells with Conditional Formatting
In some cases, you may want to copy cells that contain conditional formatting. Excel does not allow you to copy and paste the formatted values directly; however, with a few additional steps, it is possible.
Use Paste Special
1. Select the cells with conditional formatting and press Ctrl + C (Windows) or Command + C (Mac).
2. Right-click on the destination cell where the values should be pasted and select Paste Special from the menu.
3. In the Paste Special dialog box, select Formatting, then click OK.
4. Your formatted values will now be pasted into the destination cell without any formulas or conditional formatting.
Use Format Painter
1. Select the cells with conditional formatting and press Ctrl + C (Windows) or Command + C (Mac).
2. Select the destination cell where the values should be copied, then select Format Painter from the Home tab of the ribbon.
3. Your formatted values will now be pasted into the destination cell without any formulas or conditional formatting.
Copy/Paste FAQs
Q: Can I copy/paste values from a formula-based cell?
A: Yes, you can copy and paste the values from a formula-based cell by using Paste Special.
Q: How do I paste values into multiple cells at once?
A: You can select multiple cells before pasting your values, or you can use the Copy and Paste menu items on the Home tab of the ribbon.
Q: Can I copy/paste values from cells with conditional formatting?
A: Yes, you can copy and paste values from cells with conditional formatting by using either Paste Special or Format Painter.
Q: How do I paste values without a formula?
A: To paste values without a formula, use Paste Special and select Values. Alternatively, you can use the Copy and Paste menu items on the Home tab of the ribbon.
Copying the Value in Excel Without the Formula
can be a useful timesaver. With the steps outlined above, you can quickly and easily get the values you need without having to enter formulas or manually copy/paste multiple times.