I want by dragging (autofill) =‘ref’!A1 =‘ref’!A5 =‘ref’!A9 … etc how do i change the autofill rate so that each new reference cell is increased by 4 (instead of default 1)?
There is an option in the autofill menu called step value (Edit>Fill>Series). Change the step value = 4.