BookmarkPrint
Contents
Home > Microsoft Office > Excel > Copy Cells: Double Click Auto Fill Handle - Excel


Copy Cells: Double Click Auto Fill Handle - Excel
You can double click on the fill handle to copy cells based on the location of the active cell. This article shows Excel 2016, but this process also works in Excel 2013 & 2010.
Quick links to sections in this article:
Cell Below Active Cell is Occupied       Cell Below Active Cell is Blank
Cell to Left of Active Cell is Blank  Cell to Right of Active Cell is Blank
The fill handle is located in the bottom right corner of the active cell. The pointer will turn into a +.

Fill Handle Cell Below Active Cell is OccupiedIf there is something in the cell below the active cell,

Cell Below Active Cell Occupied

the active cell will be copied down the column until it encounters a blank cell in the current column.

Copy Until Blank Cell in Current Column
 Cell Below Active Cell is BlankIf the cell below the active cell is empty,

Cell Below Active Cell Blank

the active cell will be copied down the column until it encounters the end of the data in the column to the right.

Copy Until End Data Right
 Cell to Left of Active Cell is BlankIf the cell to the left of the active cell is empty,

Cell Left Blank Cell Empty

the active cell will be copied down the column until it encounters an empty cell in the column to the right.

Copy Until Empty Cell to Right
 Cell to Right of Active Cell is BlankIf the cell to the right of the active cell is empty,

Cell Right Active Cell Blank

the active cell will be copied down the column until it encounters an empty cell in the column to the left.

Copied Until Empty Cell to Left
Related Articles
 Author: karperc Last Updated: 1/28/2020 3:07 PM   Page Views: 2043
<< Change Uppercase to Proper Case - Excel Copy Cells: Double Click Auto Fill Handle - Excel  Count Occurrences - Excel >>
helpdesk.etown.edu/helpconsole2012/kb/default.aspx?pageid=copy_cells