Fill Series as default when drag-n-drop

hajiali

Active Member
Joined
Sep 8, 2018
Messages
486
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.
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
2,061
Office Version
  1. 365
Platform
  1. Windows
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,628
Messages
5,838,447
Members
430,549
Latest member
jayjay2022

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top