How to Enter Same Information for Multiple Cells in Spreadsheets

When you use Kingsoft Spreadsheets to make worksheets, sometimes you might need to enter the same information into multiple different cells. What did you do in such circumstance? Type into one cell and then copy and paste into other cells? Here is a quick tip on how to enter same info for multiple cells at once.

Enter Same Information for Multiple Cells

Step 1 Select the cells into which you want to enter the same data. The cells do not have to be adjacent. You can press Ctrl to select multiple cells which are not adjacent.

Step 2 Release Ctrl key and type a piece of text, data, time or any content that you want to, but don't hit the Enter key. Instead, hold down the Ctrl key and press Enter at the same time.

Completed! Now you will see all the selected cells are displaying the same information that you have just entered.

How to select multiple cells

To Select	Do This
A range of cells	Click the first cell of the range, and then drag to the last cell.
All cells on a worksheet	Click the Select Allbutton.
Nonadjacent cells or cell ranges	Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges.
An entire row or column	Click the row or column heading.
Adjacent rows or columns	Drag across the row or column headings. Or select the first row or column; then hold down SHIFT while you select the last row or column.
Nonadjacent rows or columns	Select the first row or column, and then hold down CTRL while you select the other rows or columns.