Provides friendly Word processing, Spreadsheets & Presentation software.

|
Kingsoft Office > Support for Windows Office > How to Add Same Value to Entire Column or Row using Kingsoft Spreadsheets?

How to Add Same Value to Entire Column or Row using Kingsoft Spreadsheets?

Release Date: 01-10-13

With Kingsoft Spreadsheets, you can add the same value to an entire column or row, or a range of selected cells, so that each cell value is incremented with the same value. This useful feature is called Paste Special. Follow these steps to use Paste Special.

Step 1 Open the spreadsheet file you want to edit with Kingsoft Spreadsheets.

Step 2 Enter the value you'd like to add in a blank cell (any cell, and you can delete it later).

For example, we have a worksheet like the following, and we will add the same value of "300" to the cells from A1 to A5. So we type the value of "300" in a blank cell.

Step 3 Use Ctrl+C to copy the cell "300", and then select cells from A1 to A5. Then right click on the selected cells to select Paste Special from the drop down menu.

Step 4 The Paste Special dialog will pop up. In this dialog, under Operation, select Add and finally press OK. Your data will be incremented with the same value of 300. Please remember to delete the value "300" you've entered.

use paste special to add same value to entire column use paste special to add same value to multiple cells

Use the similar method, you can choose to substract, multiply and divide the selected range of cells with the same value you specify. Just select corresponding operation from the Paste Special popup window.

This paste special feature is not restricted to columns. You can hold Ctrl + left mouse button to select multiple cells, either from a column, but also from a row. and the cells don't have to be continuous.