I am not sure I understood your query.

Use relative column referencing after selecting the entire range. Below are
the different reference styles.

A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.

"Going Crazy with excel" wrote:

I have developed a rule for a column of data.
=$ak$7:$ak$11
=$ak$4:$ak$6
I want to repeat this same rule to adjacent columns, AL thru AS.
Then I want to repeat the same rule for the range AK15 AK22 THRU
AS15 AS22.
Is there a way to repeat this same formula without re entering the same
formula throughout the entire workbook?
Any help would be greatly appreciated.