Fill Series as default when drag-n-drop

hajiali

Active Member
Joined
Sep 8, 2018
Messages
282
Office Version
  1. 2016
Platform
  1. Windows
is there a way to have excel to only allow Fill series instead of copy cells when dragging the + sign down. For example if I input value #2 in a2 and i slecect cell a2 and drag the + (bottom right of cell) to only go to 3,4,5,6 etc, instead of copying the value #2 .

If there is a way to default this to happen when the workbook is opened that would be wonderful.

Any suggestions is greatly appreciated.
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,768
Fill Series is only going to work if you select at least two cells. Copy happens when you select only one cell

If you only give it one value, Excel doesn't know how to fill the cells down. Example:
A2 = 2
A3 = 3
Select cells A2:A3
Pull the + down

I did a search and cannot find a way to disable copy with the + fill handle.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,518
Messages
5,529,312
Members
409,862
Latest member
lbisacca
Top