Excel fill column with same value

Fill the same data into adjacent cells

1. Tap to select the cell that contains the data you want to fill into other cells, and then tap the cell a second time to open the Edit menu.
2. Tap Fill, and then tap and drag the fill arrows down or to the right.

1. How do you fill column with same value in Excel without dragging?
2. How do I auto fill a column in Excel?
3. How do I fill a column with the same data in sheets?

How do you fill column with same value in Excel without dragging?

Keyboard shortcut: You can also press Ctrl+D to fill the formula down a cell in a column, or Ctrl+R to fill the formula to the right in a row.

How do I auto fill a column 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 a column with the same data in sheets?

Use autofill to complete a series

In a column or row, enter text, numbers, or dates in at least two cells next to each other. Highlight the cells. You'll see a small blue box in the lower right corner. Drag the blue box any number of cells down or across.