Thread
:
=SUM('Wkly stats'!$E6) How do i unfreeze the 6 when i drag cell
View Single Post
#
1
Posted to microsoft.public.excel.misc
AP1927
Posts: n/a
=SUM('Wkly stats'!$E6) How do i unfreeze the 6 when i drag cell
I have place a string infront of E because thats the column i require.
I want to unlock the 6 so the number changes 7,8,9 as i drag the formula
across..
Reply With Quote
=SUM('Wkly stats'!$E6) How do i unfreeze the 6 when i drag cell