WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to copy value without formula in Excel?

August 9, 2022
51.6K Views

When you are working in excel Excel/Spreadsheet WPS, copying and pasting is frequently performed from one cell to another. Most people get confused and found very difficult to excel copy value not formula and paste  in a cell.

As when they copy data from a cell, it not only copies the content from that cell but also the format such as background color, font color and formula within it. While you only want to copy values not formula within it.

However Using WPS excel/spreadsheet is very simple and helpful only if you know the right steps and methods. This article will help you to understand the steps involves how to copy values not formula from data as values in excel/spreadsheet WPS and after reading the article you can easily perform this task in your WPS excel/spreadsheets (2016/2019/mac/online).

Followings are the simple steps to be followed to easily understand this task,

Different ways How to copy value not formula in Excel Spreadsheet (2016/2019/Mac/Online)

Part 1: Using Paste Values Command

Discover a simple and effective way to copy values without formulas in Excel. Part 1 will guide you through the "Paste Values" command, allowing you to retain only the data you need without any unwanted formulae.

Step 1: Select the cell or range of cells containing the values you want to copy.

Step 2: Right-click on the selected cells, and from the context menu, choose "Copy."

Copy function



Step 3: Now, right-click on the destination cell where you want to paste the values.

Step 4: In the context menu, locate and click on "Paste Values." This will paste only the values without any associated formulas.

Paste Values function



Part 2: Using Paste Special Command

Take your Excel skills to the next level with Part 2, where we delve into the powerful "Paste Special" command. Learn how to copy and paste values without formulas effortlessly, providing a quick and efficient solution for your data manipulation needs.

Step 1: Copy the cells with the values you wish to transfer to another location as usual.

Copy cells



Step 2: Right-click on the destination cell where you want to paste the values.

Step 3: In the context menu, find and select "Paste Special."

Past Special



Step 4: A dialog box will appear. Within the dialog box, choose "Values" and click "OK." This will paste the values without any formulas.

Past Values tools



Part 3: Using Special Keyboard Shortcut– Ctrl+Alt+V

Time is of the essence! Part 3 unveils a nifty keyboard shortcut - Ctrl+Alt+V - that will speed up your value-copying tasks. Say goodbye to time-consuming manual processes and effortlessly copy values in Excel with just a few keystrokes.

Step 1: Highlight the cells containing the values you want to copy.

Step 2: Press and hold the "Ctrl" and "Alt" keys on your keyboard simultaneously.

Step 3: While holding down these keys, press "V." This will open a small Paste Special menu.

Past Special table



Step 4: Release the keys and press "V" again to paste values. Alternatively, you can use the arrow keys to navigate to "Values" and press "Enter" to paste.

Past Values table



Part 4: Using Alt+E+S+V Keystrokes

Time is of the essence! Part 3 unveils a nifty keyboard shortcut - Ctrl+Alt+V - that will speed up your value-copying tasks. Say goodbye to time-consuming manual processes and effortlessly copy values in Excel with just a few keystrokes.

Step 1: Select the cells containing the values you want to copy.

Step 2: Press and hold the "Alt" key on your keyboard.

Step 3: While holding down the "Alt" key, press "E," followed by "S," and finally "V."

Step 4: Release the keys to open the Paste Special dialog box

Past Values Shortcut


.


Step 5: Within the dialog box, select "Values" and click "OK" to paste only the values.

Past Values result


 

Part 5: Why Use WPS Office?

WPS Office logo



Discover the advantages of using WPS Office in Part 5. Uncover the reasons why this powerful productivity suite is the perfect companion for your Excel endeavors, offering seamless compatibility, robust features, and an intuitive interface to enhance your overall office experience.

For a seamless Excel experience and beyond, choose WPS Office. Here's why:

  1. Price: Enjoy powerful features at an affordable cost.

  2. Compatibility: Easily work with Microsoft Office formats.

  3. Features: Access a wide range of productivity tools.

  4. User-friendly Interface: Intuitive and easy-to-use.

Make the smart choice and elevate your office experience with WPS Office. To learn more about the advantages of using WPS Office over other office software, check out the following references:

FAQs about excel copy value not formula

How can I convert formulas to values in Excel?

To convert formulas to values in Excel, follow these simple steps:

Step 1: Select the cells containing the formulas that you want to convert to values.

Step 2: Right-click on the selected cells and choose "Copy" from the context menu, or you can use the keyboard shortcut "Ctrl + C" to copy the cells.

Copy cell



Step 3: Right-click on a different cell where you want to paste the values. In the context menu, hover over "Paste Options," and then select "Values" from the options.

Past values



Alternatively, you can use the "Paste Special" feature:

Step 1: Select the cells containing the formulas.

Step 2: Press "Ctrl + C" or right-click and choose "Copy" to copy the cells.

Copy cell



Step 3: Right-click on a different cell and select "Paste Special" from the context menu.

Step 4: In the "Paste Special" dialog box, choose "Values" and click "OK." This will paste the values from the copied cells without any formulas.

Past values dialog box



By following these steps, you can easily convert formulas to values in Excel and keep only the desired data in your spreadsheet.

How to verify cell values without formulas?

To verify if cells contain values without formulas in Excel, just follow these steps:

Step 1. Select the cells you want to check.

Step 2. Look at the formula bar above the worksheet grid.

formula bar



Step 3. If it displays the actual value (numbers, text, dates) and not a formula, the cell contains a value without any formulas.

Step 4. If you see a formula expression (e.g., "=A1+B1"), then it contains a formula.

formula expression



Can I copy values without formatting in Excel?

Yes, you can copy values without formatting in Excel. When you copy cells from one location to another, you have the option to paste only the values without carrying over any formatting from the source cells.

Summary

In this article, we explored various methods to copy values without formulas in Excel, simplifying data manipulation tasks. The methods included using "Paste Values" and "Paste Special" commands, as well as convenient keyboard shortcuts like Ctrl+Alt+V and Alt+E+S+V. We also highlighted the advantages of using WPS Office, a powerful and cost-effective productivity suite. WPS Office offers seamless compatibility, a rich set of features, and an intuitive interface, making it an ideal companion for all your office needs. Elevate your Excel experience with WPS Office and unlock a world of productivity possibilities.


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.