See all How-To Articles

How to Fill Column With Same Value in Excel & Google Sheets

This tutorial demonstrates how to fill a column with the same value in Excel and Google Sheets.

 fillcolumn intro

Fill a Column With the Same Value

Excel has a few tools you can use to quicky replicate cell data down a column. You can use the fill handle, a keyboard shortcut, or copy-paste.

The Fill Handle

When you select a cell in Excel, the bottom right-hand corner of the cell contains a small square. This is known as the fill handle. If you click on the fill handle and drag your mouse down some rows, the cells you’ve dragged over are filled with the relevant data when you let go of the mouse button.

  1. To copy data using the fill handle, select the cell that contains the data.

fill column handle

  1. When you rest your mouse on the fill handle, your mouse pointer changes to a small black cross. You can then hold down the mouse button and drag this cross down however many rows you need.

fillcolumn handle filled

  1. Once you let the mouse button go, the cells you’ve dragged over are filled, by default, with the value in the first cell (Copy Cells).

fillcolumn handle copied

This works for both text and values.

Keyboard Shortcut

  1. Select the range of cells where you wish your data to go.

fillcolumn select range

  1. With the range selected, type in the text you wish to fill the range.

fillcolumn handle type text

  1. Press CTRL + ENTER to fill the column with your text.

fillcolumn data copied

This works for both text and values.

Copy and Paste

  1. Type your data into the first cell.

fillcolumn copy data

  1. In the Ribbon, select Home > Clipboard > Copy (or press CTRL + C).

fillcolumn copy ribbon

  1. Highlight the cells in the column where you wish the data to be pasted to.
  2. Then in the Ribbon, select Home > Clipboard > Paste (or press CTRL + V).

fillcolumn copy paste

The data is replicated down the column of cells.

fillcolumn copy pasted

Fill Column in Google Sheets

Two of the Excel methods above (the fill handle and copy-paste) can be used the same way in Google Sheets to fill a column with data.

fillcolumn gs copy