DRAG and FILL will not increment if copied from another workbook

dcm043

New Member
Joined
Feb 19, 2016
Messages
3
Working in EXCEL 2013, I can copy a cell from another workbook, but I cannot drag the formula and have it increment so that it copies the next cell from that workbook. It just copies the formula from the original cell. The Drag and Fill works if I am copying from cells within the same worksheet. And I have tried copying 2 consecutive cells and dragging them, but that just copies those 2 cells.

I tried FILE>OPTIONS>ADVANCED>Enable fill handle ... (It was already checked) and holding down CTRL while dragging and right click dragging. Nothing works.
 

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.

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,907
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Can you post the copied formula just as it appears in the formula bar before you try to drag it? Do you want to drag it down or across?
 

dcm043

New Member
Joined
Feb 19, 2016
Messages
3
Can you post the copied formula just as it appears in the formula bar before you try to drag it? Do you want to drag it down or across?

Sorry for the false alarm. The cells had $ in them. It seems to be working OK now.
 
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,149
Messages
5,835,683
Members
430,375
Latest member
datdog22

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