What To Do When Excel Shows Link Instead of Values

When we are working in Excel/Spreadsheet WPS (2016/2019/Mac/Online), there are a number of times when we have to copy data from one sheet into another sheet. When a huge number of data is being copied, sometimes on pasting that data in the desired sheet shows the link of the copied cell instead of the showing the desired value and we do not know what to do when Excel/Spreadsheet WPS (2016/2019/Mac/Online) shows link instead of value. The best way to paste values is by using some methods in Excel/Spreadsheet WPS(2016/2019/Mac/Online). These methods can easily be learned and they can show you what to do when Excel/Spreadsheet WPS (2016/2019/Mac/Online) shows link instead of value. In this way, we can save ourselves from getting stuck at any point in our work and get the desired result. 

Pasting values instead of links in Excel/Spreadsheet WPS (2016/2019/Mac/Online) is very easy but most people do not know what to do when Excel/Spreadsheet WPS (2016/2019/Mac/Online) shows link instead of value. There are different ways for doing this task. After following the below-mentioned steps, anyone can easily know what to do when Excel/Spreadsheet WPS (2016/2019/Mac/Online) shows link instead of value.

Excel/Spreadsheet is an easy-to-use tool that helps its users by providing so many different methods for processing and categorizing data within a few minutes. The following steps will help you understand What to do when Excel/Spreadsheet WPS (2016/2019/Mac/Online) shows link instead of value. After reading all the steps, you will be able to paste values in excel/spreadsheet WPS (2016/2019/Mac/Online) instead of links.

Method When Excel/Spreadsheet WPS (2016/2019/Mac/Online) Shows Link Instead Of Value

Using Paste Special Button When Excel/Spreadsheet WPS Shows Link Instead Of Value

1.Open the worksheet in Spreadsheets (WPS Office) from which the links are to be copied.

2.Copy the link by Right-Clicking on the link cell and then clicking on Copy OR by pressing Ctrl+C keys when the desired cell has been selected.

3.Move to the cell where the value is to be pasted.Click on the Paste button on Home Tab and then click on Paste Special.

4.A new dialog box will open. Under the Paste Section, select Values and then Click on OK.Your desired value will be pasted in the cell instead of link.

Using Right Click When Excel/Spreadsheet WPS Shows Link Instead Of Value

1.Open the worksheet in Spreadsheets (WPS Office) from which the links are to be copied.

2.Copy the link by Right-Clicking on the link cell and then clicking on Copy OR by pressing Ctrl+C keys when the desired cell has been selected.

3.Move to the cell where the value is to be pasted and Right-Click on that cell.

4.Move the cursor to Paste Special. 

5.Then move the cursor to Paste as Values.Your desired value will be pasted in the cell instead of link.

Note: Sometimes, links are shown instead of values even after using the above method. In such a case, you need check two things, first check if in the Number Section of Home Tab, the option from drop-down menu is set to General. Secondly, check if in the Formulas Tab the ‘Show Formulas’ button is not pressed.

This article has covered the method what to do When Excel/Spreadsheet WPS (2016/2019/Mac/Online) Shows Link Instead Of Value. You can use these simple steps as explained above and easily know what to do when Excel/Spreadsheet WPS (2016/2019/Mac/Online) shows link instead of value whenever required.

Hopefully, you have learned what to do when Excel/Spreadsheet WPS (2016/2019/Mac/Online) shows link instead of value by following the above steps.  If you want to know more about Excel features, you can follow WPS Academy to learn. You can also download WPS Office to edit excel spreadsheets, word documents, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.