How to Use Paste Special to do Calculations in Kingsoft Spreadsheets

Perhaps you know that in Kingsoft Spreadsheets, you can use Paste Special to do simple calculations to the worksheet data. The calculations include add, subtract, divide and multiply. Follow these steps to use Paste Special.

Step 1 In the worksheet that you want to make the calculation (in this example, column B), enter the number you want to add, subtract, multiply by or divide by in one cell (or a column). In this example, we enter the value into column C.

Step 2 Select C2 to C8 and press Ctrl + C to copy the range to clipboard. Then select B2 to B8, and go to Home > Paste. Click on Paste button to open the drop-down function list. Select Paste Special from the list.

Step 3 The Paste Special dialog pops up. Here you can choose the operation you want to do on the selected range. For example, we choose Add and press OK to apply to the selected range in column B.

You will see that Spreadsheets adds the value you copied to the Clipboard to every value in the selected range. To do other calculations, simply select from the operation list.