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

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
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?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,214,525
Messages
6,120,051
Members
448,940
Latest member
mdusw

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
Back
Top