Number Locking Not Working

tthebert

New Member
Joined
Oct 24, 2012
Messages
31
Hi all,

I am creating a Covariance Matrix and trying to do so by locking certain ranges so I can drag the formulas across and downward.

But for some reason, the letter section of my range will not lock. For example,

D$5:D$159

Should return an E$5:E$159 for the next row if the formula is dragged downward.

But, it continues as D$5:D$159.

If I lock the "D", as in $D5:$D159, the number DOES change.

If I lock both the letter and the number, nothing changes; which is the same result I get from just locking the number.

Are there any thoughts on why this might be?

Thanks guys.

Troy
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Dragging downwards increments the row reference not the column reference, which increments when you drag to the right. If you post your formula someone may be able to amend it.
 

Forum statistics

Threads
1,136,324
Messages
5,675,096
Members
419,549
Latest member
EliteBeat

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