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.
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,388
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,499
Messages
5,596,517
Members
414,074
Latest member
Matthew Kakde

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