How to fill multiple cells in Excel

While using Microsoft Excel, you may need to enter same values such as text, data in multiple cells, or enter same formula into an entire column at once in case of avoiding typing them one by one. In this tutorial, you will learn how to quickly enter same data or formula in cells at once.

Enter same data in multiple cells at once with Ctrl + Enter in Excel
Enter same formula into an entire column with Enter in a table in Excel

Enter same data in multiple cells at once with Ctrl + Enter in Excel

For entering same data in cells, please do as follows.

1. To select multiple cells which you want to enter same data by holding the Ctrl key.

2. After selecting, please press the Space key, and the last selected cell is in the editing mode.

3. Type the dada or text in the cell, and then press Ctrl + Enter keys simultaneously.

Now all selected cells are entering with same content. See screenshot:

Note: If there are contents in the selected cells, it will replace all contents of selected cells with the same data after press the Ctrl + Enter keys.

Enter same formula into an entire column with enter key in a table in Excel

Supposing you have data in column A and B, and you want to sum these data in column C with the Enter key. Please do as follows.

1. Select cell C2 and press Ctrl + T keys at the same time.

2. In the popping up Create Table dialog box, select the data range you want to sum, and click the OK button. See screenshot:

Note: If there is data header in your range, check the My table has headers box.

3. Select the column B and right click it. Then select Insert > Table Column to the Right in the right-clicking menu.

4. You can change the header name of the new column by selecting it and entering a new name in the Formula Bar, and then press the Enter key.

5. Select the first cell of the new column, here I select the cell C2. Enter the formula in this cell, and then press the Enter key.

After pressing the Enter key, all cells in this specified column are populated with same formulas at once.

In Microsoft Excel, you can enter the same data or text into multiple cells at once using the below simple steps.

1. Highlight all the cells that you want to have the same text.
2. Type the text you want.
3. After typing the text, instead of pressing Enter, press Ctrl+Enter.

After completing the steps above, the text automatically is entered in all highlighted cells. This tip is useful if you have data with the same prefix and need to add something to the end of each cell.

For example, the steps above were done to enter "computer hope" in all the highlighted cells, as shown in the picture. Once completed, I could press F2 on a selected cell, go to the end, and add "1" to make the cell "computer hope 1". I could keep doing this for each cell to have computer hope 1 through 16.

Microsoft Excel offers several tools you can use when you need to fill a column with the same text or numbers. Instead of completing each cell manually, you can quickly fill in the entire column using one of the three techniques below. Each of the tools varies slightly in its implementation, but they all provide the same results.

Keyboard Shortcut

1. 1.

   Select the range of cells in which you want to enter the same data.

2. 2.

   Type the data. The entry appears in the first selected cell.

3. 3.

   Press "Ctrl-Enter" on the keyboard. Excel fills the other cells in the column with the same value.

Fill Handle

1. 1.

   Enter the data into the first cell in the column.

2. 2.

   Click the cell to select it, and then hover your mouse pointer over the bottom right corner of the cell until your pointer turns into a black "+" sign. This corner is the "fill handle."

3. 3.

   Click the fill handle and drag it down until you cover the desired rage of cells in the column, and then release the mouse button. Excel copies the value in the first cell to the other cells.

Copy and Paste

1. 1.

   Enter the data into the first cell in the column, and then press "Enter."

2. 2.

   Right-click the cell and select "Copy."

3. 3.

   Select the other cells in which you want to repeat the same data.

4. 4.

   Right-click anywhere on the selected range of cells, and then click the first clipboard icon under "Paste Options." Excel pastes the copied data into all of the selected cells.

   How do you AutoFill multiple cells in Excel?

   Put the mouse pointer over the bottom right-hand corner of the cell until it's a black plus sign. Click and hold the left mouse button, and drag the plus sign over the cells you want to fill. And the series is filled in for you automatically using the AutoFill feature.

   How do I fill multiple cells with the same text?

   Insert the same data into multiple cells using Ctrl+Enter Select all the blank cells in a column. Press Ctrl+Enter instead of Enter. All the selected cells will be filled with the data that you typed.

   How do I fill 1000 rows in Excel without dragging?

   Quickly Fill Numbers in Cells without Dragging.

   Enter 1 in cell A1..

   Go to Home –> Editing –> Fill –> Series..

   In the Series dialogue box, make the following selections: Series in: Columns. Type: Linear. Step Value: 1. Stop Value: 1000..

   Click OK..

   How do I AutoFill thousands of rows in Excel?

   Fill data automatically in worksheet cells.

   Select one or more cells you want to use as a basis for filling additional cells. For a series like 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. ... .

   Drag the fill handle ..

   If needed, click Auto Fill Options. and choose the option you want..