How do i copy the same number down a column in Excel

Section: Excel Basics Tutorial: Autofill Row or Column - Same DataExcel: How to FILL a Column, Row, Range with the SAME DATAWe often want to copy and paste, or replicate, cell da

How do i copy the same number down a column in Excel

Section: Excel Basics   Tutorial: Autofill Row or Column - Same Data

Excel: How to FILL a Column, Row, Range with the SAME DATA

fun image

We often want to copy and paste, or replicate, cell data into other worksheet cells, but how can we do it quickly? By using a very powerful feature of Microsoft Excel called autofill.

This comprehensive tutorial shows the Excel user how to autofill adjacent cells, selected cells that are not adjacent, or a cell range.

For related tutorials, see the Excel Autofill Information Center. This tutorial contains affiliate links. Read our disclosure policy to learn more.

Tutorial Sections

  • Autofill Adjacent Column or Row Cells
  • Autofill Selected Cells that are Non-Adjacent
  • Autofill a Cell Range

How to Autofill a Column or Row (Adjacent Cells)

There are two fast ways that an Excel user can fill adjacent cells in a column or row with the same numerical or text data. This section shows both methods.

Method #1: Ctrl + D

  1. Type the data into the a worksheet cell and Enter.
  2. Click in the cell with the data and, keeping the left mouse button pressed, drag to select the rest of the cells in the row or column that you would like autofilled.
  3. Release the mouse button.
  4. Press Ctrl + D (the Ctrl key is held while the D key is pressed) and the cells are filled.

A KeynoteSupport.com Tutorial

Method #2: Using the Fill Handle

The Fill Handle is a powerful Excel tool for autofilling a linear series, a growth series, and many other types of data.

The Fill Handle can also be used to autofill the same value AS LONG AS the value isn't a series starter. If so, Method #1 must be used. Examples of series include days of the week, month names, series involving dates, and time.

the Fill Handle
  1. Type the data into a spreadsheet cell.
  2. Place the cursor in the bottom right corner of the cell you just typed in until you see a plus sign. With the left mouse button, press and drag the Fill Handle (plus sign) to highlight all of the cells you want filled.
  3. Release the mouse button and the cells are filled with the value typed in the first cell.

Autofill Selected Cells that are Non-Adjacent

Sometimes we want to autofill non-contiguous cells in a row or column. For example, we may have an empty row between each data row for readability, but now want to autofill part of a column. Use the technique below to autofill individually selected worksheet cells.

image that shows process for autofilling selected cells
  1. Select the individual cells you want autofilled by pressing and holding the Ctrl key as you click inside the cells. Figure 1 shows that we have selected cells A1, A3, A5, and A7.
  2. After clicking in the last cell, type the number or text value you want autofilled in the last cell (figure 2).
  3. Press Ctrl + Enter key and the selected cells will be autofilled (figure 3).

How to Autofill a Cell Range with the Same Data

The methods in the first section of this tutorial do not work if you wish to autofill a range of cells that covers multiple columns and rows (2-dimensional). Use the technique described below.

images that show autofilling cell range
  1. Select the range of cells you wish to autofill by pressing and holding the left mouse button while dragging the cursor (figure 1).
  2. Type the numerical or text value you wish to autofill (figure 2).
  3. Press Ctrl + Enter key and the selected cells will be autofilled with the value you typed (figure 3).

Return to the top

link to our Excel Autofill Information Center

Top Excel Pages

  • How to Link & Sum Worksheet Data
  • How to Insert Rows, Columns & Cells in a Worksheet
  • How to Lock Cells & Protect Worksheets
  • How to Conditionally Format with Color Scales
  • How to Subtract Dates from Today's Date in Excel

Top Reads

  • Beginner's Guide to Accounting
  • The AVERAGEIF Function of Excel
  • All About Your Credit Report

Recommended

(affiliate link)

Search Keynote Support

Video liên quan